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 |
|
ServerTeam
Yak Posting Veteran
83 Posts |
 Posted - 2009-02-03 : 10:20:16
|
| Hi All,I am refreshing a database.Database is in replication..Here my question is ..Do we need to drop replication before refreshing database.Here before refreshing database i am Killing SPID's on this database.Thanks,ServerTeam |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-03 : 23:54:14
|
quote:
Originally posted by ServerTeam
Hi All,I am refreshing a database.Database is in replication..Here my question is ..Do we need to drop replication before refreshing database.Here before refreshing database i am Killing SPID's on this database.Thanks,ServerTeam
I am not clear why you need to refresh database involved in replication. Do you want to preserve replication properties? |
 |
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2009-02-04 : 10:12:53
|
| Here in my Environment we do weekly refreshes from productionHere 'xxx' databases is core DB in my project and this is in replication.AFter doing refreshes i want to add all replication back..Thanks,ServerTeam |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-04 : 11:04:18
|
| http://msdn.microsoft.com/en-us/library/ms152560.aspx |
|
|
|
|
|
|
Drop replication