Troubleshooting Configuration Problems
There are two specific techniques that you can use to resolve SQL Server configuration problems. In this section, you will learn how to recover from a bad configuration and how to rebuild the master database.
Recovering from a Bad Configuration
Although SQL Server 2005 has many safeguards that help you avoid configuration settings that keep SQL Server from starting, you may occasionally find that a configuration change prevents SQL Server from starting. If you encounter this situation, you can recover the server instance by completing the following steps:
Log on to the affected server locally, or log on remotely through Telnet or Terminal Server. You must log on using a local administrator account or the account ...
Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
