System Crash

  • 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

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

  • 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"

  • 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