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.
I have found in discussion forums regarding the error given below when you try to delete a job that was part of maintenance.
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.
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.
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.