How to rebuild master database

If you lost master database (because of disaster) and you are on server, where was not important data (linked servers, users etc…) you can rebuild (create new clean ) all systém databases.

.\setup /ACTION=REBUILDDATABASE /INSTANCENAME=<instance_name> /SQLSYSADMINACCOUNTS=<win_admin_account> /SAPWD=<sa_password>

This action create new master, msdb, model and tempd databases.

Leave a Reply

Your email address will not be published. Required fields are marked *