llkaauto.blogg.se

Rebuilding master database in sql server
Rebuilding master database in sql server




Select the instance to repair and press Next. Go to Maintenance and select the Repair option. To use this option, follow these steps: Run the setup.exe in your SQL Server installer folder. Select a consistency check to be run after the restore.Īfter the restore, SQL restarts in multi-user mode. This option will allow you to repair the SQL Server database, including the master database. To ensure that Backup Exec has access rights, verify that the account that Backup Exec uses has administrator rights to the computer that is running SQL. If Backup Exec does not have access to the SQL registry keys HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server and HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer, then a restore to the default directory may not work, and the option Automate master database restore on the restore job properties for SQL will not work. When this option is selected, only the master database can be restored if this option is selected for any other database, those jobs will fail. On the Restore Job Properties for SQL dialog box, select Automate master database restore.Īll existing users are logged off, and SQL Server is put into single-user mode. On the Properties pane, under Settings, click Microsoft SQL. On the restore selections list, select the backup set containing the last master database backup. On the Properties pane, under Source, click Selections. But you cannot see any user defined databases. On the navigation bar, click the arrow next to Restore.






Rebuilding master database in sql server