Question

Auto recovery - sql replication

  • 20 February 2024
  • 4 replies
  • 24 views

Userlevel 1
Badge +13

i have sql server backup to on premsie disk and i have a media agent and storafe in azure cloud 

 

i want to do replication to azure storage from there i need to do restore a vm where i have created instance 

 

but i dont see an ioption to select the copy to replicate it from 


4 replies

Userlevel 5
Badge +14

Hello @Ajal 

You can follow these guides on setting up SQL Replication.

Replicationhttps://documentation.commvault.com/2023e/expert/replication_01.html

Keep up-to-date copies of production databases on alternate servers, thus minimizing down time in cases where the production database server has failed. The advantages of Warm Database Restore over a traditional restore scenario is that the database is always kept in a near ready state. In the case of disaster, users do not need to wait for the time it would take to restore the database in its entirety. Only the latest backup may need to be applied to the target database before turning the application over to use it.
SQL Server - Restore to a Hot Standby Server - https://documentation.commvault.com/2023e/expert/sql_server_restore_to_hot_standby_server.html

Replication for MySQL - https://documentation.commvault.com/2023e/expert/replication_for_mysql.html

 

Thank you,
Collin

Userlevel 1
Badge +13

@Collin Harper  my question is not this,

i have dash copy of sql server, i want to replicate from the dash copy .how do i do that?

the option inder auto recovery sql server doesnt provide option to select which copy.

 

so i assume its replicsting from primary copy

Userlevel 1
Badge +13

@Collin Harper  if you can refer the auto recovery option under that sql database you can see, this explains how to create replication group for sql .

but i am not getting an option to choose the from which copy .

 

Userlevel 1
Badge +13

https://documentation.commvault.com/2023e/essential/replication_of_sql_databases_01.html

Reply