.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to back up SQL 2005 with TLog files

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server

We are using SQL 2005 (SP3) and I have catered a maintenance plan that back ups the database.
I read several articles about the back up of SQL 2005 which confused me and raised few questions in my mind. I am not very familiar with SQL 2005 , so feeling uncomfortable what I am doing for taking the back up of the database.

Every hour our database is pulling data from another server which generates reports and charts for the management. Data volume is fairly huge and must have to have very well planed maintenance in case of disaster we can recover maximum data. Maximum one hour's data loss is appreciated.

Now what I'm doing -
1. Taking backup of our DB once in a day at 12:00AM and
2. Backing up TLog file every hour.

Database back up type if full (Recovery Model: Full). Instead of creating separate backup files, I'm appending the existing file (If Backup File Exist: Append).
For the TLog backup system I'm doing the same - not creating any separate backup file for hourly backup, appending the existing file.

Now my confusions are:
Am I taking the backup correctly, or doing anything wrong (company will be in big risk without any perfect backup plan)

From different articles I found that people suggeste

View Complete Post

More Related Resource Links

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

How to generate pdf from 2005 rdl report files from command prompt?

Hi All, I have a scenario like this, i have 10 rdl reports, which needs to run on a job basis with out any user interaction. Tell me is there any way to generate the pdf from command prompt using existing 2005 rdl files. Your help is more appreaciated!! Thanks, Sarvesh M  Sarvesh

Multiple XML files into SQL SERVER Express 2005

Hello. I am familiar with classic ASP and use this with MS SQL SERVER EXPRESS. I have an SQL table and want to import multiple XML files into this on a daily basis. I currently have 3 files, transferdata.vbs which loops through the XML files. FAQschema.xml which maps XML to the SQL database and test.xml shows the xml in the test file. If I run transferdata.vbs I get the following error "Error opening the data file" line 33 char 3. Microsoft Bulkload for SQL Server". My SQL table is called EnqOrd id (int), Debitor (varchar), PurchaseDate (varchar)     transferdata.vbs set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad") objBL.ConnectionString = "Provider=SQLOLEDB; Data Source=XXXXXX\XXXXX; Initial Catalog=XXXX; User ID=XXXXX; Password=XXXXXX" objBL.ErrorLogFile = "E:\fuelsql\Teccom\error.log" ' Here is the path to your XML files Const path = "E:\fuelsql\Teccom\XML\" Dim Text, Title, oFile Dim fso, oFolder, oFiles, wsh ' Object variables Text = "Folder " Title = "XML Files" Set wsh = WScript.CreateObject("WScript.Shell") ' Create FileSystemObject object to access the file system. Set fso = CreateObject("Scripting.FileSystemObject") ' Get Folder object. Set oFolder = fso.GetFolder(wsh.ExpandEnvironmentStrings(path)) ' Get All Files Set oFiles = oFolder.

Sql Server 2005 backup misses files

I have a SQL Server 2005 database that contains 3 files.  Sometimes when I run rhe backup, it appears to only backup 2 of the three files.  The only way I can get it to return to a full backup is to restore the database from a backup tape.

Encrypting .bak files - Sql server 2005

Hi all, What options are there available to encrypt .bak files in SS2005 I'm aware of TDE in SS2008, but that seems to be only available in the Enterprise version? the company would only agree to upgrade to standard 2008 version. I'm aware I can password protect a .bak file, but that's not encrypted and can be opened in notepad. Should I be looking for third-party solutions? Regards Melt      

Connections to SQL Server Files (*.mdf) require SQL Server Express 2005

When ever I click on an MDF file in VS2005 I get the following message.Required Components Missing.Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly.  Please verify the installation of the component or download from the URl: http:go.microsoft.com/fwlink/?linkID=49251.I think this may have been due to the install order and options I selected.1. VS2005 Pro, without SQL Server Express 2005 as I was planning to install SQL2005 Developer.2. SQL2005 Developer.I then noticed the above problem and installed SQL Server Express 2005 from the VS Pro DVD.  I still have the problem.  Any ideas how I can fix this ?

Updation of .mdf and .ldf files of sql server 2005


Hello All,

I have sql server 2005 database, which is hosted on my dedicated server.The issue is whenever i look into the default location of the .mdf and .ldf files, it shows me date of back 8 months as last modified date, although the data objects are fully updated as we make new objects everyday.

I thought it could not be a serious problem and downloaded the files to local server, then after i attached a new database by using those files and changing their names. I was wondered that it showed me the old data almost of 8 months back.

I don't know what is the problem, why these files on the server are not updating, if anyone has the solution please alert me as possible.



Software developer

WPF- Back/Forward navigation UI not working when Html web files are displayed in Frame Control


I am integrating (web) html files in my WPF application using Frame (say Source=http://www.microsoft.com)

I set the JournalOwnership="OwnsJournal" and


The navigation UI is visible and disabled initially when the page loads up (which is fine), but when I click on links the Back/Forward button is not enabled.  Interestingly the context menu shows Back/Forward and I can navigate that way. Do you have pointers?


Thanks for your help.

Back up SQL 2008 Express files


Hi All,

I'm running Visual Studio 2008 Express that comes with SQL 2008 Express.

I have developed a web site with a SQL 2008 Express database. I need to upload the database as a .bak backup file to the server that can host the web site.

How do I create that backup of the database ? There seem to be no tools that come with SQL Express to back it up. 

Free applications like SQLBackupandFTP only seem to back up the system databases - not hose created in projects. 

I downloaded SQL Express SP2 but that doesn't seem to have made any difference either !?

I think I need a script file - using T-SQL but I'm not a SQL programmer so any help would be appreciated !


connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly



i've installed SQL server 2005 express and Visual web developper 2005 express.

when i whant to create a database in VWD the following error occures:

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=49251

i searched the internet but can't find the solution, i already reinstalled my complete workstation but the problem stays.

please help!

Visual Studio 2005 can't find my files in subfolders, why?!


I am having a heck of a time with this.  Visual Studio 2005 SP1 can not find my files and javascript files whenever I put it in the subfolders.  In the solution explorer, I've created subolfders such as /js and /css.  This is inside my main folder:  AJAXEnabledWebApplication1\css  and AJAXEnabledWebApplication1\js

In HTML code, when I put this: <script type="text/javascript" src="js/jquery-1.4.2.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.core.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.widget.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.mouse.js"></script>
    <script type="text/javascript" src="ui/jquery.ui.selectable.js"></script>

every single one of them is highlighted that it can not find the specified file.  But wait, if I add those files manually to the root folder and to the solution explorer, it is no problem!!?? why?!?

why is this happening?

inside the reference paths for the program, I've also pointed to the root folder location:

c:\document adn settings\myname\my Docum

How to get a mdf file back from sql files recovered from SQL Recovery Toolbox?



I had a corrupted mdf file so I purchsed SQL Recovery Toolbox to fix it. When it repaired the file, it spat out a number of sql files and an install.bat file. Because the file was a sql 2008 express file, i'm supposed to now use sqlcmd.exe to fix it. Apparently to get it back to a mdf file, I need to create a blank database and somehow use sqlcmd.exe to import the sql files into the new mdf file.

I use a security program which installs sql express 2008 during the install. I don't know how to use MS Sql. The security program I use has it's own batch file to attach or detatch the two mdf and ldf file to it. I emailed the SQL Recovery Toolbox tech support for instructions on how to created a new mdf db and import the repaired sql files but they basically said that they have an agreement with MS and cannot tell me how to do it.

Can someone please let me know what to do or where to look for assistance? I am stuck at the moment and don't know what else to do.

Any help greatly appreciated, cheers.  

Saving PDF files seamlessly back to Sharepoint


We're running Sharepoint 2007 Enterprise. We have a document library which contains soft copies of faxes receved from customers in PDF format. Staff in our Service Centre need to be able to:

- open a PDF file
- make edits to it (e.g. in Adobe Acrobat Professional)
- save the file back to Sharepoint.

I know there's a workaround to save the PDF to the local PC and then go back into Sharepoint and load it back into Sharepoint - but this is too time-consuming and error-prone. While it's a very straighforward and seamless user experience for MS Office files type such as Word or Excel, we have spent literally months trying to figure out how to do this for PDF files and have still not come up with a workable solution. The closest we got was to use some software called SwiftWriter from Omtool, but unfortunately it doesn't work on folders containing more than 366 files.

Does anyone have a solution for this?

SQL Server 2005 rebuild indexes find corruption or cross linked files


Does anyone know if this is a known issue? What do you do when this happens? We had to go to a good backup from 3 days prior.

From the application log it appears there were cross linked files. Is this caused by the OS or Sql Server?

Pat M


PatM Reno

Error Handling loading Excel Files with SSIS 2005


I have an SSIS job which watches a directory for new files being submitted. On detecting a file(s) it determines the process to perform on it (based on the file name) and then reads in the file, loads it into the database, and deletes the file. All is fine. I want to add error handling though, specifically for the instance where the worksheet name does not correspond to that defined in the Excel Connection manager for this file.

At the moment if I change the sheet name to be different to that defined in the connection manager, the job fails and so (in turn) the whole process ceases (i.e. the for loop also goes to status failed).

I have tried event handler variables and checkpoints but without success. Could someone give me some advise, or point me to a article that would help?


How to upload files to remote machine using FTP or other method in VB.Net 2005 (Windows Application)



I have to create an application to upload and download files using FTP.
Are there any classes, methods in VB.Net 2005(Windows Application) to do this?

I have created a small GUI for this.

It contains 4 text boxes - Path of Local file to be uploaded, IP address of remote machine, User name and password of remote machine At last there is one Transfer button when I click on this transfer button that file should get copied to the remote machine.


I tried this using FTPWebRequest class by reading example in msdn.

But to connect to remote machine it requires URI format of FTP and I only have IP address of that remote machine. I think there is no web server on that remote machine.

Should I need to install web server on that remote machine.

Or is there any other method to do upload files to remote machine ?


what log files are available in SQL Server 2005 ?



Please guide me what log files are avaialble in SQL Server ? like I heared transation log and error log. Are there some other log files in SQL Server ?

how to configure them, please advice

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend