Solved

Live Sync Some SQL Databases are not there

  • 12 January 2023
  • 5 replies
  • 109 views

Badge +1

When setting up the live sync two of the nine databases show in the General tab of the SQL Live sync options, on the primary server.  The backup server has all but one show in the SQL live sync options.  What would cause the databases to not show?  These servers are identical with the same versions of windows server and SQL running on them.  I need to have all of the databases replicated to the backup server.

icon

Best answer by Mike H 12 January 2023, 22:36

View original

5 replies

Userlevel 3
Badge +6

@IThomas 

 

What recovery model is the DB you do not see in?  

Badge +1

They are in simple recovery on the primary server.  They are also on simple recovery on the backup server that the databases do show up on SQL live sync.

Userlevel 3
Badge +6

They are in simple recovery on the primary server.  They are also on simple recovery on the backup server that the databases do show up on SQL live sync.

@IThomas 

Live Sync only supports databases in the Full Recovery Model:

https://documentation.commvault.com/2022e/expert/92005_replication_of_sql_databases.html

 

Badge +1

Then why do they show up on the backup server?  The servers SQL databases are identical. 

Userlevel 3
Badge +6

Then why do they show up on the backup server?  The servers SQL databases are identical. 

Are you talking about the Commserve DR Live Sync process?

Reply