locked
Dead SQL server RRS feed

  • Question

  • Hi folks

    An SQL server at work is pretty much dead but I can still access the location where the mdb and ldf files are, so I'm making a copy of them quickly before the server dies completely.  I was wondering what I can do with them though once I have copied with them.  If I build a new SQL server, then can I import these files somehow? 

    Thanks!

    Thursday, August 26, 2010 4:02 PM

Answers

  • Hi,

    If you are able to connect the database, please take backup from server. Connect database server and select database and right click. choose backup database option.

    If server is dead, copy mdf and ldf files to safe place. Build a new server and place mdf and ldf files on proper location and attach them.

    If you check internet you can get lot of db attach articles.

     I am giving few sample articles.

    http://www.mssqlcity.com/Articles/Adm/attach_database.htm

    http://technet.microsoft.com/en-us/library/ms190209.aspx


    Ramesh S
    www.sequalserver.com
    • Proposed as answer by Tom Li - MSFT Monday, August 30, 2010 11:02 AM
    • Marked as answer by Tom Li - MSFT Sunday, September 5, 2010 8:53 AM
    Thursday, August 26, 2010 4:15 PM

All replies

  • Hi,

    If you are able to connect the database, please take backup from server. Connect database server and select database and right click. choose backup database option.

    If server is dead, copy mdf and ldf files to safe place. Build a new server and place mdf and ldf files on proper location and attach them.

    If you check internet you can get lot of db attach articles.

     I am giving few sample articles.

    http://www.mssqlcity.com/Articles/Adm/attach_database.htm

    http://technet.microsoft.com/en-us/library/ms190209.aspx


    Ramesh S
    www.sequalserver.com
    • Proposed as answer by Tom Li - MSFT Monday, August 30, 2010 11:02 AM
    • Marked as answer by Tom Li - MSFT Sunday, September 5, 2010 8:53 AM
    Thursday, August 26, 2010 4:15 PM
  • 1) Take the backup of master and MSDB .You can also keep the login information from master using KB http://support.microsoft.com/kb/246133 .In that case there is no need to take the backup of master .

    2) Rest of the databases can be attached later (make sure you have all the LDF ,NDF and MDF files)

    3) Get the version of SQL Server byusing select @@version or xp_msver

    4) install the new instance of SQL Server

    5) make sure that you are on the same patch level as before (in step 3)

    5) Restore master or create the logins that you would save from step 1 .Restore MSDB

    7) attach the rest of the user databases

    HTH

    Abhay

     

    • Proposed as answer by Abhay_78 Monday, August 30, 2010 9:08 AM
    Friday, August 27, 2010 4:45 AM
  • Thanks for the info, will give these a try :)
    Monday, August 30, 2010 11:12 AM