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.
Solved
Live Sync Some SQL Databases are not there
- Novice
Best answer by Mike H
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.
Live Sync only supports databases in the Full Recovery Model:
https://documentation.commvault.com/2022e/expert/92005_replication_of_sql_databases.html
- Novice
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.
- Vaulter
- Answer
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.
Live Sync only supports databases in the Full Recovery Model:
https://documentation.commvault.com/2022e/expert/92005_replication_of_sql_databases.html
- Novice
Then why do they show up on the backup server? The servers SQL databases are identical.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.