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 |
|
deepakshi
Starting Member
1 Post |
 Posted - 2005-09-07 : 04:42:08
|
| Hi,I am having two SQL servers which are replications of each other. One is master database and other one is slave. Somebody by mistake manually copied the SQL tables in one of the databases and now none of them is working. Can you tell us how to correct the problem?RegardsDeepakshi |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-07 : 04:51:32
|
| please post the errors you are seeing.-ec |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-08 : 01:41:11
|
rerun the snapshot with option to drop and recreate the tables,my guess you're missing the reference column for replication to workdon't forget to re-apply the permissions afterwards...quote:
Originally posted by deepakshi
Hi,I am having two SQL servers which are replications of each other. One is master database and other one is slave. Somebody by mistake manually copied the SQL tables in one of the databases and now none of them is working. Can you tell us how to correct the problem?RegardsDeepakshi
--------------------keeping it simple... |
|
|
|
|
|
|
Replication Error