SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring SQL Sever 2000 Database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

globemast
Starting Member

32 Posts

Posted - 06/27/2003 :  09:18:57  Show Profile  Reply with Quote
Hello.

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..

Page47
Flowing Fount of Yak Knowledge

USA
2878 Posts

Posted - 06/27/2003 :  11:08:30  Show Profile  Reply with Quote
You can use the RESTORE DATABASE command.

Jay White
{0}
Go to Top of Page

Shastryv
Posting Yak Master

USA
145 Posts

Posted - 06/27/2003 :  12:24:20  Show Profile  Visit Shastryv's Homepage  Send Shastryv an AOL message  Send Shastryv a Yahoo! Message  Reply with Quote
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

globemast
Starting Member

32 Posts

Posted - 06/28/2003 :  03:41:56  Show Profile  Reply with Quote
can i restore from a network path?

Go to Top of Page

sanjnep
Posting Yak Master

USA
191 Posts

Posted - 06/29/2003 :  00:35:46  Show Profile  Visit sanjnep's Homepage  Reply with Quote
Yes you can restore database back from network path.If you need detail step please write me again.
Good luck.
Sanjeev


Sanjeevshrestha
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000