Skip to main content
Solved

SQL System Databsases Restore via Command Center


Forum|alt.badge.img+7

Hi together,

currently we are trying to move operation from Commcell Console to Command Center.

In the case of a SQL-Server restore we discovered that it is not possible to restore the SQL system databases (model/master/msdb) with the Command Center.

In the Commvault Console we have the “Include System Databases” tick-box in the advanced restore options … but there are no advanced restore options in the Command Center.

There is an additional setting named “bEnableAdvancedRestoreOptionsMSSql… but this seems to serve a different purpose.

Do I miss something?

Thank you.

Regards.

Michael

Best answer by Tanuj Balani

Hello @Michael Seickert 

 

Thanks for your query.

 

System databases don't appear for restore from Command Center and that they must be done through advanced restore option from Commcell Console with 'include system databases' option during the browse.
 
In the Command Center, they are only available when restoring an entire instance. 
If needed, you would use instance-level recovery documented here: (Command Center) 
https://documentation.commvault.com/v11/essential/147482_restoring_sql_server_instance.html
 
If you needed to restore them individually that procedure is here, which is only done from the Commcell Console. 
https://documentation.commvault.com/v11/expert/18252_restoring_sql_system_databases.html

View original
Did this answer your question?

12 replies

Forum|alt.badge.img+8

 Hi @Michael Seickert 

 

Could you try to provide the following permissions on the SQL client and see if that helps?

 

Browse

Out-of-place Recover

In Place Recover


Forum|alt.badge.img+4
  • Vaulter
  • 34 replies
  • Answer
  • August 11, 2023

Hello @Michael Seickert 

 

Thanks for your query.

 

System databases don't appear for restore from Command Center and that they must be done through advanced restore option from Commcell Console with 'include system databases' option during the browse.
 
In the Command Center, they are only available when restoring an entire instance. 
If needed, you would use instance-level recovery documented here: (Command Center) 
https://documentation.commvault.com/v11/essential/147482_restoring_sql_server_instance.html
 
If you needed to restore them individually that procedure is here, which is only done from the Commcell Console. 
https://documentation.commvault.com/v11/expert/18252_restoring_sql_system_databases.html


Forum|alt.badge.img+7
Nutan Pawar G wrote:

 Hi @Michael Seickert 

 

Could you try to provide the following permissions on the SQL client and see if that helps?

 

Browse

Out-of-place Recover

In Place Recover

Hi Nutar,

thank you for your reply.

we were trying the restore with an account of the master group. It seems to be no permission related issue.

Regards.

Michael


Forum|alt.badge.img+7
Tanuj Balani wrote:

Hello @Michael Seickert 

 

Thanks for your query.

 

System databases don't appear for restore from Command Center and that they must be done through advanced restore option from Commcell Console with 'include system databases' option during the browse.
 
In the Command Center, they are only available when restoring an entire instance. 
If needed, you would use instance-level recovery documented here: (Command Center) 
https://documentation.commvault.com/v11/essential/147482_restoring_sql_server_instance.html
 
If you needed to restore them individually that procedure is here, which is only done from the Commcell Console. 
https://documentation.commvault.com/v11/expert/18252_restoring_sql_system_databases.html

Hi Tanuj,

thank you for the quick response and for the clarification.

Best regards.

Michael


Forum|alt.badge.img+8
  • Byte
  • 60 replies
  • August 11, 2023

Hello @Michael Seickert,

 

Command Center does provide ways to restore your system databases, but it is the restore complete instance procedure:

https://documentation.commvault.com/2023/essential/147482_restoring_sql_server_instance.html

 

Regards,

Mike


Forum|alt.badge.img+7
mikevg wrote:

Hello @Michael Seickert,

 

Command Center does provide ways to restore your system databases, but it is the restore complete instance procedure:

https://documentation.commvault.com/2023/essential/147482_restoring_sql_server_instance.html

 

Regards,

Mike

Hi Mike,

thank you for you reply. Yes, the system databases are restored via an instance restore … but if you have a large instance, this will be no option.

I will stay with the Commcell Console.

Regards.

Michael


Onno van den Berg
Commvault Certified Expert
Forum|alt.badge.img+19

Did you open a CMR for it? I'll also try to poke some people who I know within Commvault. The future is Command Center, so you should deliver this ability in there as well. 


Forum|alt.badge.img+7

Hi Onno, this would be a good idea, if I would have some more time …

There are missing so many features in the Command Center (check any advanced attribute ..).

Furthermore: The last 4 CMR that I made were closed after 6 months.


Onno van den Berg
Commvault Certified Expert
Forum|alt.badge.img+19

What kind of CMRs and were they closed with remark implemented or were they closed without proper follow-up? 


Jos Meijer
Commvault Certified Expert
Forum|alt.badge.img+17
  • Commvault Certified Expert
  • 638 replies
  • August 14, 2023

From Command Center perspective, when you go to the backup history of the SQL instance, click on the differential backup, browse that for recovery and you should see the system databases.


Onno van den Berg
Commvault Certified Expert
Forum|alt.badge.img+19

Just checked it what @Jos Meijer stated and it's also possible in case of a full. So I assume this workaround works for all types expect transaction log. Not sure if the restore actually works, but you can select only the system DBs. 


Forum|alt.badge.img+14

@Michael Seickert / @Jos Meijer  / @Onno van den Berg 

There is an existing CMR# 358938

If there is anyone requesting this message me your CCID, and I can add you to the CMR.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings