The rebuild process of system databases is a complex and risky task in the SQL server.
This should be handle with care & should be performed by experience database administrator.
so it's important to carefully follow the necessary steps. Steps to rebuild the system databases in SQL Server is given below:
1. Check whether you have latest db backup of all system & user databases.
2. If possible, take help of Windows Team to take Cohesive/Snapshot backup for safer side.
3. Stop SQL Server services as well as SQL Server Agent.
4. Change the directory which has SQL server Installation media.
5. Run the following command in command prompt.
setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLServer
/SQLSYSADMINACCOUNTS=<AccountNameWithAdminRights> /SAPWD=password /SQLCOLLATION=collation
6. Press enter to start installation process.
7. During the installation process, select option to rebuild system databases.
8. Now need to select authentication mode and specify sa password.
Next Step.....Coming Soon...
No comments:
Post a Comment