If your database files are not corrupt (.mdf and .ldf) - the best thing
to do would be to attach them back to your server.

If you restore from a full backup, you would lose all of the
transactions that happened after the backup was taken to this point in time.

Ramesh Phogat wrote:
> 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
>
--
Cheryl Bach ~ University Information Technology Services
~ Administrative Computing ~ University of Arizona

Peace cannot be kept by force. It can only be achieved by understanding. - Albert Einstein

"Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." Albert Einstein


MS Sql Server LazyDBA home page