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?
Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.