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 |
|
deepikasyam
Starting Member
4 Posts |
 Posted - 2006-10-18 : 00:30:47
|
| I have set replication in my database X. I have both publisher and distributor existing in the same server where my database X exists.Am also creating subscriptions to databases in various other servers from here itself.(i.e push subscription)If i restore database X, will my replication settings be affected ?Do i have to create publications all over again, after restore. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-18 : 04:28:39
|
| afaik, no, unless the publications and subscriptions at that time were different--------------------keeping it simple... |
 |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2006-10-18 : 10:21:19
|
| Was your backup taken while replication was all set up ? If your backup was prior to replication being setup, then I'm pretty sure it will get screwed up. Doesn't take much to cause problems in replication.It might be a good idea to script out publications & subscriptions just in case. |
|
|
|
deepikasyam
Starting Member
4 Posts |
Posted - 2006-10-19 : 05:27:58
|
| Yes the backup is from an earlier date, prior to setting replication. So i guess, a restore would mess up the replication settings.Anyways, thanks so much for the info ! |
|
|
|
|
|
|
Does restore affect database replication settings