jseabird
06-17-04, 11:53
Hello.
I have a problem in SQL Server 2000, in WINDOWS 2000 server ,peer to peer TCP/IP based LAN.I have 2 DATABASE servers and some database on each one with Replication between them.
1) I make a "Complete BACKUP" from one database from Distributor ( or Publisher )Server.
In another LAN, Like I mentioned, I have 2 DATABASE servers too. I RESTORE the Backup file on 2 servers.
But I can’t setup Replication between them because my backup file contains some information of replication in it.
2) If I should make backup file from Subscriber Server, I wont have any problem with Replication.
I have a problem in SQL Server 2000, in WINDOWS 2000 server ,peer to peer TCP/IP based LAN.I have 2 DATABASE servers and some database on each one with Replication between them.
1) I make a "Complete BACKUP" from one database from Distributor ( or Publisher )Server.
In another LAN, Like I mentioned, I have 2 DATABASE servers too. I RESTORE the Backup file on 2 servers.
But I can’t setup Replication between them because my backup file contains some information of replication in it.
2) If I should make backup file from Subscriber Server, I wont have any problem with Replication.