Category Archives: Troubleshooting

Moving System Databases – SQL Server 2005

There are lots of articles, Links and sites that describe how to move system databases from the SQL default location to the location described by the DBA but still lot of users find difficult while moving them and land up in trouble. So I thought of writing an article for moving the databases so that the users can use the same and enjoy the task.

Continue reading Moving System Databases – SQL Server 2005

Dedicated Administrator Connection

SQL Server 2005 provides a special diagnostic connection for administrators when standard connections to the server are not possible. This diagnostic connection allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests.

Continue reading Dedicated Administrator Connection

How to Rebuild System Databases in SQL Server 2005

We need to rebuild the system databases if the master database is corrupted or damaged. Let us discuss in detail how to rebuild system databases in SQL server 2005.

Step 1: Take a full backup of all the System and User databases prior to rebuilding the system databases as we need to restore it later to avoid data loss.

Continue reading How to Rebuild System Databases in SQL Server 2005