Skip to main content
Answer

SQL System Databsases Restore

  • May 4, 2022
  • 2 replies
  • 1303 views

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.

Best answer by Bart

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

 

 

If you have a question or comment, please create a topic

2 replies

Bart
Novice
Forum|alt.badge.img+12
  • Novice
  • Answer
  • May 4, 2022

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

 

 


Jos Meijer
Community All Star
Forum|alt.badge.img+16
  • Community All Star
  • May 4, 2022

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