Solved

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

  • 30 September 2021
  • 3 replies
  • 40 views

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

icon

Best answer by Mike Struening RETIRED 7 October 2021, 21:41

View original

3 replies

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

Badge +8

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? 

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

Reply