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)
 HELP Recovery needed

Author  Topic 

mb
Starting Member

16 Posts

Posted - 2002-02-04 : 08:52:04
Ive rebuilt my master dataabases and have subsequently lost all my user databases. I still have all the data file and transaction logs, is there any way I can recover this?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-02-04 : 09:35:38
sp_attach_db will allow you to reattach the MDF files. Check Books Online, there are some limitations. You might also try sp_attach_single_file (something like that, it's in BOL under sp_attach_db)

Go to Top of Page
   

- Advertisement -