Please start any new threads on our new site at 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 Sever 2000 Database

Author  Topic 

Starting Member

32 Posts

Posted - 2003-06-27 : 09:18:57

My SQL Server 2000 crashed recently and i lost all my databases. Thankfully i had them backup up two days before the crash on a secondary hard disk. Can you please tell me how to restore the Databases which i backed up.

Thank you..

Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-06-27 : 11:08:30
You can use the RESTORE DATABASE command.

Jay White
Go to Top of Page

Posting Yak Master

145 Posts

Posted - 2003-06-27 : 12:24:20
Go to EM and Databases -> All Tasks -> Restore Databases -> Specify DB name in the 'Restore as Database' -> From Device -> Choose the backup file path

Go to Top of Page

Starting Member

32 Posts

Posted - 2003-06-28 : 03:41:56
can i restore from a network path?

Go to Top of Page

Posting Yak Master

191 Posts

Posted - 2003-06-29 : 00:35:46
Yes you can restore database back from network path.If you need detail step please write me again.
Good luck.

Go to Top of Page

- Advertisement -