Skip to main content
Question

Livesync databases SQL

  • 2 April 2024
  • 1 reply
  • 20 views

Forum|alt.badge.img

hello,

I configured the SQL Server database livesync schedule, I would like to do a DR test, on the DR website the databases are in recovery status.

1 - How to run a test on just one database?

2 - After executing and leaving only one database running on the DR site, how do I return the database to the production site with the updated data?

1 reply

Chris Hollis
Vaulter
Forum|alt.badge.img+15

Hi @carvalhos 

Are you referring to this? 

https://documentation.commvault.com/2024/expert/sql_server_restore_to_hot_standby_server_01.html

 

Or are you talking about the Commserves SQL Database? (CS Live Sync)?


If you’re talking about SQL itself, you would apply the latest logs with recovery option enabled (apply log backups only) as per these isntructions here:

https://documentation.commvault.com/2024/expert/restoring_sql_transaction_logs_to_hot_standby_server.html

 

Hopefully this helps!

Regards,

Chris


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