Skip to main content

Hi,

I have recently been asked if it is possible to restore SQL System Databases without restoring all User Databases in the same SQL instance?

I thought this could be possible in CV however I cant find any way to do so via Web/Java console, only user Databases are listed when attempting to find master, model and msdb..

 

Any help or thoughts on this would be great appreciated.

https://documentation.commvault.com/v11/expert/18252_restoring_sql_system_databases.html

 

  • From the CommCell Browser, click Client Computers > client > SQL Server.

  • Right-click the instance, and then click All Tasks > Browse and Restore.

  • In the Browse and Restore Options dialog box, click Advanced Restore, then click the Advanced Options tab.

  • Select Include System Databases, and then click View Content.

so the trick is to select Advanced restore and then click advanced options

 

 


In addition to Bart, if you are restoring from the command center you need to select your differential backup in order to recover system databases