0
votes
2answers
116 views

Synch SQL 2008 with failover server?

Currently they have a single SQL 2000 Std install on a server that needs to be retired. They run an app in terminal services to manipulate the data. So I'm looking at two new servers with SQL 2008 ...
0
votes
1answer
65 views

Implications of renaming sql server 2000 instance

I have a sql server 2000 of which I want to replicate the data to a sql server 2008. However the output from select @@servername and select serverproperty('servername') on the 2000 server are ...
0
votes
1answer
41 views

Do I need to disable access to a publisher database when setting up SQL Server 2000 Transactional Replication?

I have a production database i.e. where there are constant updates and I've configured this to be published to another server using Transactional Replication. When I configure transactional ...
0
votes
2answers
162 views

Can SQL Server 2000 replicate system databases and/or logins?

Can SQL Replication be used to publish SQL Server 2000 system databases to another SQL Server 2000 server, i.e master, model, msdb? If this is not possible, what is the correct strategy for keeping ...
1
vote
1answer
183 views

How do I push my initial snapshot to a subscriber server in SQL Server 2000?

I'm configuring Transactional Replication using the Push model. The scenario is: The SQL Servers: SQL01 (publisher) and SQL02 (subscriber) - both running SQL 2000 SP4. Both servers are ...
3
votes
1answer
100 views

What replication options exist between SQL Server 2000 and 2005?

We have a business partner that is still on SQL Server 2000, and we would like to replicate a couple databases to one of our SQL Server 2005 instances. The business partner databases that we need to ...
0
votes
1answer
3k views

Replication between SQL 2008 & SQL 2000 - Across network (DMZ) - process could not connect to Subscriber

I have 2 servers... OTTO is located on site, and connected to domain It is running SQL 2008. I have created the database, in SQL 2000 compatability mode. WEBDB3 is located in datacenter, not ...
0
votes
1answer
68 views

Altering a SQL 2000 table that is replicated

I have a database that is published, and a seperate server subscribes to this publication. We are using Transactional Replication (as far as I can tell) I need to alter a column on ServerA (the ...
0
votes
2answers
155 views

Monitoring replication using System Monitor

I have an MS SQL 2000 server that uses transactional replication and a request to user System Monitor and check if replication is doing ok and not affecting performance of the server. Any tips on ...
0
votes
2answers
441 views

SQL 2008 Replication corrupt data problem

We took a SQL 2000 database. Took a lightspeed backup. Restored on SQL 2008 active/passive cluster. Then setup replication to replicate the data back to SQL 2000. So 2008 is the publisher/distributor, ...
0
votes
2answers
446 views

SQL Server Merge Replication merge agent gone missing

We've got a pair of SQL2000 servers that are syncing a couple of databases using merge replication. At some stage in the last few months, the merge agent for one of the databases disappeared. It's ...
4
votes
4answers
1k views

SQL 2000 Replication error - The subscription(s) have been marked inactive and must be reinitialized

We have a largish database (350GB) which is replicated to a subscriber which is georaphically in a different location. Unfortunateley we have a slow connection between the two sites. Today we're ...
1
vote
1answer
370 views

Is there an undocumented way to reinitialize a replication subscription via transact-sql in SQL Server 2000

Is there an undocumented way to reinitialize a replication subscription via transact-sql in SQL Server 2000, or do you have to use Enterprise Manager or SQL-DMO as mentioned in SQL Server Books ...