How to Recover Crashed SQL Server with existing datafiles and logs

Posted: April 1, 2008 in Sqlserver

  1. Before installation of SQL Server take the backup of existing Datafiles and Transaction logs.
  2. Rename the datafiles and transaction logs for all system databases master,model, msdb and pubs to file_name_OLD.mdf and file_name_OLD.ldf.
  3. Install the SQL Server.
  4. Stop the services for SQL Server.
  5. Rename the New datafiles and Transaction logs for all system databases to file_name_NEW.mdf and file_name_NEW.ldf.
  6. Rename the Old datafiles and transaction logs for all system databases to Original name file_name.mdf and file_name.ldf.
  7. Start the services for SQL Server.
  8. Check all user and system Databases exists on the server and nothing is offline.
  9. Verify the sql server and windows logins.
Advertisements

Comments are closed.