Saturday, January 17, 2015

Performing a SQL Server Repair operation

If for some reason your instance of SQL Server stops working or starts encountering problems, you might think that by running a "Repair" from the installation dialog will resolve the issue.

Unfortunately, a Repair only repairs the installation if you have all of your databases intact including the master database.  If one or more system databases such as the master database have become corrupted, a Repair operation is not really for you.

Instead, you will have to try and figure out some other method of restoring the system databases (hopefully you have system database backups) such as by running a Rebuild of the System databases such as outlined in this article:

No comments:

Post a Comment