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 |
|
nathans
Aged Yak Warrior
938 Posts |
 Posted - 2004-08-26 : 13:07:18
|
| I have a transactional publication currently running on PROD1 to subscriber DEV1. I am restoring PROD1 from a .bak file and want to know if the restore will 'overwrite' the replication publication.I know I need to disable replication before restoring, but afterwards will the publication still be there? Hopefully all I need to do is re-enable it?Thanks guys |
|
|
Mike2265
Starting Member
6 Posts |
Posted - 2004-08-31 : 06:14:53
|
| Can't really help here but, if you try it, I'd be curious to know if it does. Every time I've restored I've recreated all my subscribers. It wouldn't surprise me if sql server can't link the two together again because the db IDs might be out of wack. I've found the whole area of dropping subscriptions and publications etc to be a bit tenuous. Try to delete the lot from the top level or do it from the wrong area in enterprise manager and only half the info is deleted and you need to create a new one under a different name because it's impossible to get rid of all the info (and we tried hard). That's our experience anyway and permit me to use this forum to bitch about it. Probably safer to just recreate it again each time after unsubscribing, deleting publication and then removing replication from the publisher if unplanned downtime is an issue. This can be done pretty quickly if you have a T-SQL script that creates your publication for you. I think this can be generated from an existing publication - but don't quote me on that.Cheers,Mike |
 |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2004-08-31 : 12:19:00
|
| I ended up doing it all manually... I did come across something in BOL that may preserve replication, though I havent had the time to test it. Check the WITH KEEP_REPLICATION option under RESTORE in BOL. Anyone familiar with this? |
|
|
|
|
|
|
Will Restore overwrite Replication Settings?