Question

Livesync databases SQL

  • 2 April 2024
  • 1 reply
  • 16 views

Badge

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

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

Reply