Solved

restore a DB from within sql management studio

  • 5 January 2023
  • 2 replies
  • 216 views

Badge +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

icon

Best answer by Scott Reynolds 5 January 2023, 13:26

View original

2 replies

Userlevel 6
Badge +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

Badge +1

Hi Scott

Thx alot I will try it out. :)

Br Martin

Reply