Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-07 : 07:44:32
|
| Jennifer writes "I have three NT 4.0 servers with SP4. They all have SQL7.0 with SP2. I setup replication for a database (MyDB) from Server1 to Server2 to Server3 started around November 2000. I also have MyDB backup to a file every night in these three servers.Server1 is a publisher for Server2 and only 1/3 of tables needed to be replicated to other two serveres. Server2 is a distributor, a subscriber (pull subscriptions from Server 1) and a publisher (push subscriptions to Server3).Server3 is a subscriber. I got a request to “frozen database” for each month starting 3/2002. I setup my users to access the “frozen database: MONTHLY” from Server2. I did the following. A) Copied the backup file S1.BAK from Server1 to Server2. B) Restored it to Server2. Everything was functional. Because of space issue on Server2, I decided not to copy a 4GB S1.BAK from Server1 to Server2. I just took S2.BAK from Server2 and restored it to MONTHLY. After restored completed, I found out that the Distribution Agent from Server1 to Server2 was stopped successfully and I had no way to restart it because the choices of START and STOP were all gray-out. I even restarted all three servers to see if the agent would start, but no use. I had to removed all publications and subscriptions among these three servers and re-do the whole replication again; however, after I recreated them, the Distribution Agent from Server1 to Server2 still had START and STOP gray-out. What should I do? I have been re-creating the whole thing every month since May 2002. Please advice. ThanksJennifer" |
|
|
|
|
|
Replication Distribution Restore