August 7, 2007 at 12:45 pm
I have SQL Server 2000 installed on Windows 2000 Server platform. Now suddenly the operating system crashes i.e. it doesn't boot. The OS was installed on C: drive and the SQL Server database is on D: drive.
I have installed a fresh copy of Windows 2000 and SQL Server 2000 also.Now what options do I have to restore the database?
Thanks in advance
August 8, 2007 at 12:49 am
Well, if you still have the data and log file on the D:\ drive you can just attach them again. In Enterprise Manager, right-click "Databases" go to "All tasks" and select "Attach Database..."
If you had DTS packages and scheduled jobs you will have to restore the system databases (master and msdb) too...
August 9, 2007 at 3:54 am
I hope the above post helped you this time.
you need to have a solid disaster recovery plan this is a primary job of a DBA.
There are so many articles in the net. Please review this link about disaster recovery articles.
http://www.sqlservercentral.com/articles/articleList.asp?categoryid=57
Minaz
"More Green More Oxygen !! Plant a tree today"
August 24, 2007 at 2:39 pm
to attach system databases this link might be helpful. http://support.microsoft.com/kb/224071/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply