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?
-
lobo519
- Veteran
- Posts: 315
- Liked: 38 times
- Joined: Sep 29, 2010 3:37 pm
- Contact:
-
Gostev
- Chief Product Officer
- Posts: 31814
- Liked: 7302 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: SQL Replication
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
- Veteran
- Posts: 315
- Liked: 38 times
- Joined: Sep 29, 2010 3:37 pm
- Contact:
Re: SQL Replication
So how do I replicate if there is no primary key on that table??
-
Gostev
- Chief Product Officer
- Posts: 31814
- Liked: 7302 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: SQL Replication
Sorry, I have no idea about SQL replication and cannot give you an advice here...
Who is online
Users browsing this forum: Bing [Bot] and 58 guests