Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 restoring sql database using .mdf or .ndf or .ldf files

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-06-05 : 10:02:37
Rahul writes "How to restore a database if the backup file is missing and you have only the .mdf, .ndf and .ldf files. You also do not possess the empty database."

robvolk
Most Valuable Yak

15732 Posts

Posted - 2006-06-05 : 10:02:57
You read Books Online under "sp_attach_db".
Go to Top of Page

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2006-06-06 : 10:38:25
right click databases , all tasks and do attach.
Go to Top of Page
   

- Advertisement -