All Questions
Tagged with sql-server-2000 replication
8 questions
1
vote
2
answers
129
views
Breaking database replication
I am trying to break replication between two SQL 2000 databases. Can this be done while the databases are live? or do they need to be taken offline?
- 11
0
votes
0
answers
53
views
Replication Conflict tables in SQL Server 2000
Due to previous several replications during these years in a database I'm working with, there are several tables with names with this format : *onflict_AllData_[Tablename]
which * can be a, b, ...
...
- 153
0
votes
1
answer
251
views
SQL Server 2000 Replication
I have a challenge with replication on SQL Server 2000. The replication has full permissions, but still I get this below error. The SQL Server 2000 is installed on the C: Drive, but the database is on ...
- 33
6
votes
1
answer
1k
views
How to replicate from SQL Server 2000 to SQL Server 2008 R2?
I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.
I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.
Primary key fields are not ...
- 269
3
votes
2
answers
2k
views
Cleaning up transaction replication del/ins/upd stored procedures?
I'm referring to the ones that start with:
dbo.sp_MSdel...
dbo.sp_MSins...
dbo.sp_MSupd...
I've noticed they are not removed when I run exec sp_dropsubscription on the Publisher then run ...
- 943
5
votes
1
answer
939
views
How unsafe is it to change the data source of repl_distributor on a publisher
Here's my situation.
Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication
Reporting Server was migrated to new SAN
Reporting Server fatally crashed ...
- 10.8k
5
votes
2
answers
2k
views
Log Reader replication agents are constantly restarting
I am recreating (push) transactional replication from a SQL 2000 instance to a SQL 2008 instance which I had to break in order to do a db migration. The 2008 instance is both the distributor and a ...
- 10.8k
8
votes
1
answer
1k
views
Transactional replication from SQL Server 2000 to 2008
I have legacy databases on two SQL Server 2000 servers that I am trying to replicate to a SQL Server 2008 R2 database using transactional replication.
The 2008 server is not in the same LAN, so I am ...
AndyL