Ramesh,

A database consists of an .mdf file (data) and an .ldf file (transaction log). A Full Database Backup creates a .bak file containing everthing from the data and log files at time of backup. To restore a database use the .bak file as your source. Look in Books Online (BOL) under Backup and Restore for all you need to know on the topic.

S. Davey (2/29)


MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )
517.373.1349 (MDOT)


>>> "Ramesh Phogat " <mssqldba-ezmlmshield-x41490439.[Email address protected] 02/29/08 12:05 PM >>>
Hi All,







Suppose I have Full DataBase Backup and also have .mdf and .LDF file
for the DataBase .



Now we need to restore the Database.



Please suggest which is better for me either Full DataBase Backup or
(.MDF and .LDF file) which one is choose and better for me.

Why?



Thanks & Regards



Ramesh Phogat | Tr. DB Programmer

Greenfield Online

1st Floor , Unitech Trade Centre,

Shushant Lok - 1 , Gurgaon





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page