Comprehensive data protection for all workloads
Post Reply
lobo519
Expert
Posts: 315
Liked: 37 times
Joined: Sep 29, 2010 3:37 pm
Contact:

SQL Replication

Post by lobo519 »

I am trying to setup transactional replication for the Veeam database between two sql2005 servers but it keeps erroring out when it tries to replicate the view "ReportSessionInfoView". It requires "Backup.Model.BackupTaskSessions" to create but that table is excluded from replication because there is no primary key.

Any thoughts?!?!

Can I exclude that view?

Gostev
SVP, Product Management
Posts: 26927
Liked: 4375 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Replication

Post by Gostev »

If you do not replicate the entire database including all views and tables, you will get issues if you try to connect to the second copy.

lobo519
Expert
Posts: 315
Liked: 37 times
Joined: Sep 29, 2010 3:37 pm
Contact:

Re: SQL Replication

Post by lobo519 »

So how do I replicate if there is no primary key on that table??

Gostev
SVP, Product Management
Posts: 26927
Liked: 4375 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Replication

Post by Gostev »

Sorry, I have no idea about SQL replication and cannot give you an advice here...

Post Reply

Who is online

Users browsing this forum: No registered users and 32 guests