Recover Crashed SQL Server with existing datafiles and logs

Posted: April 28, 2007 in Uncategorized

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s