Categories
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.

Categories
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.

Categories
Troubleshooting

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.

Categories
Troubleshooting

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.

Categories
Troubleshooting

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.