Skip to main content
Solved

restore a DB from within sql management studio


Forum|alt.badge.img+1

Hi :)

 

Is it possible to restore a DB from within sql management studio when using commvault for backup ? 

 

I can see restore point from within the management studio but when I try to restore it cannot as it looks on the E drive and thats not where the backup`s are located. They are located on an isiloted storrage media, do you know if it is even possible, would be nice if some admin users where able to restore without contacting the backup backend team :)

Br Martin

Best answer by Scott Reynolds

@Marty You can not just restore from the backup media. Commvault stores backups in a unique proprietary format.

You can restore SQL backups to disk location then restore in SQL management studio.

Otherwise there is a SQL plugin. This can be enabled on any SQL server and you can perform backups/restore from within SSMS. All that is needed in Commvault login.

https://documentation.commvault.com/2022e/expert/18300_commvault_plug_in_for_sql_management_studio.html

View original
Did this answer your question?

2 replies

Forum|alt.badge.img+14

@Marty You can not just restore from the backup media. Commvault stores backups in a unique proprietary format.

You can restore SQL backups to disk location then restore in SQL management studio.

Otherwise there is a SQL plugin. This can be enabled on any SQL server and you can perform backups/restore from within SSMS. All that is needed in Commvault login.

https://documentation.commvault.com/2022e/expert/18300_commvault_plug_in_for_sql_management_studio.html


Forum|alt.badge.img+1
  • Author
  • Bit
  • 1 reply
  • January 5, 2023

Hi Scott

Thx alot I will try it out. :)

Br Martin


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