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 |
|
tika
Starting Member
2 Posts |
 Posted - 2002-09-09 : 08:46:27
|
| How Can I restore Replicated DB Dear All ,I'm trying to Reestore Replicate Database I make Full Dabatase backup during replication .Firtly I face A problem "Database In use"I Solve this problem by stopping SQL Server Agent But,when I make Full Database Restore I get the following Error Message The process could not execute 'sp_repldone/sp_replcounters' on 'TABA'. The LSN (10:99:6) passed to log scan in database 'headq' is invalid.(Source: TABA (Data source); Error number: 9003)---------------------------------------------------------------------------------------------------------------The process could not set the last distributed transaction.(Source: TABA-headq-1 (Agent); Error number: 22017)--------------------------------------------------------------------------------------------------------------Can anybody Help ??? |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-09-10 : 07:23:34
|
| Hard to work out what you're setup is but have you tried stopping/removing replication prior to attempting the restore ?===========Paul |
 |
|
|
tika
Starting Member
2 Posts |
Posted - 2002-09-10 : 18:32:07
|
Dear PaulI try to Remove and Reinstall the preplication and make the new publication , then i restore the file , I got the Error ,,,I want to Tell u some thing heppen ,This Error Occured when i was tring to restore database "OLD" with Fewer Transactions (For Example the one TAble contains 2 records )But the subscriber has 3 Records From this Publisher, Any way My Setup is I Use Sql server 2000 NO service backs Installed ( But i can instal service back 2)Multi-Publisher Single Subscriber All Publishers and subscriber (win2000/sql server 2000)Replication Type "Transactional Replications"Sync. Type "Data transfer to subscriber on demand"Subscribation is "Push" Any more data i Can tell u ??Thanks For Ur help and i u know any way to backup and restore replicated database i will be happy to hear u >>>quote:
Hard to work out what you're setup is but have you tried stopping/removing replication prior to attempting the restore ?===========Paul
|
|
|
|
|
|
|
Restoring Replicated DB