Skip to main content
Answer

How to change DB name during SQL DB point-in-time recovery?

  • September 30, 2021
  • 3 replies
  • 60 views

Forum|alt.badge.img+8

I try to do SQL DB point-in-time restore, may I restore SQL DB as new database name? looks like I  have to do SQL DB point-in-time restore to original location.

Best answer by Mike Struening

Your use case is 100% supported!  Point in time restores to another location are supported:

https://documentation.commvault.com/11.24/expert/18244_restoring_sql_databases_out_of_place_moving_databases.html

3 replies

Mike Struening
Vaulter
Forum|alt.badge.img+23

Hi @xiwen !

If I may ask, what is your end goal?  You can definitely do a restore of a SQL database to another location, though I susp[ect you might be trying to initiate a point in time restore to an existing database.

Can you try this process for an out of place restore?

https://documentation.commvault.com/11.24/expert/18244_restoring_sql_databases_out_of_place_moving_databases.html


Forum|alt.badge.img+8
  • Author
  • Byte
  • September 30, 2021

We have one SQL DB called KMC, SQL DBA request to do point-in-time restore to original instance with KMC-Restore DB name.

Like like Commvailt only support restore to different instance during point-in-time restore, right? 


Mike Struening
Vaulter
Forum|alt.badge.img+23

Your use case is 100% supported!  Point in time restores to another location are supported:

https://documentation.commvault.com/11.24/expert/18244_restoring_sql_databases_out_of_place_moving_databases.html