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 |
|
krajdba
Starting Member
43 Posts |
 Posted - 2009-01-14 : 09:25:42
|
| Hi I have a 3 box publisher,Distributor and Subscriber, due to network problem Subscriber is now out of Sync with the Publisher database. How to Sync both the Publisher and Subscriber databases? Please let me know the different ways. Our publisher database is about 1.6 tera bytes. I need a fastest solution.Please give me links of the solutions?-Rajesh.Raj. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 13:53:27
|
| Do you really need 1.6TB data to be replicated to subscribers? Can you replicate only what you need. You can reinitialize subscriber. |
 |
|
|
krajdba
Starting Member
43 Posts |
Posted - 2009-01-21 : 12:53:51
|
| reinitialize subscriber takes a lot of time. Is there any other faster method.Raj. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 14:25:52
|
| For Bigger database than 100GB, We do transaction replication with backup/restore. You can apply that approach . |
|
|
|
|
|
|
Out of Sync Subscriber Database.