If you lose the master database, you will lose the login information and the path information of the database files.

Therefore, I suggest that you keep the create scripts of your jobs in a separate place.

If the Msdb database is reset, losing your jobs can cause trouble for you.

Model database does not cause problems even if reset.

You can find out how to attach your database files in the article “ How To Change The Disk Of Database Files On SQL Server(Detach Attach & Backup Restore Methods)“.īelow, I explained what should be done before and after the rebuild and the effects of the rebuild process However, you can add your databases to this new instance by attaching the database files. Your Instance will be like a newly installed instance. And you can’t see your databases on instance when you open instance.

If you rebuild your system databases while you have no backup, you will lose all your logins and jobs. But since the rebuild process will reset all the data in the system databases, you must first make sure that you have the latest backups of the system databases. Rebuild operation resets system databases and allows the system to be opened cleanly.

Because of the problems that occur in the system databases, it is sometimes necessary to rebuild.

Rebuild master database in sql server