Category: Troubleshooting
-
Unusual Backup Error in SQL Server
You might be wondering what is happening in your SQL Server when you see the error message given below. Its all simple, you need not panic.
-
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…
-
SQL Server maintenance Job Deletion Error
I have found in discussion forums regarding the error given below when you try to delete a job that was part of maintenance.
-
How to Recover SA password when you forget it – SQL 2005
What to do if you forgot SA password in SQL Server 2005? In general if you forgot SA password or if the SA account is disabled these are the options to login into SQL Server 2005 and reset or enable SA.
-
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.