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 |
|
swamym
Starting Member
1 Post |
 Posted - 2011-06-16 : 05:47:07
|
| Hi,We have a transactional replication where data transfered from Database A to Database B. The delete command wont be replicated to Database B as we need to preserve the data for the reporting purpose. Now, I want to restore the database A and B to my development box. I have following questions.1. Will the replication settings preserved if i restore with KEEP_REPLICATION option.2. is there any way to retain the data be retained in the subscriber database if i setup the replication again?Thanks, SwamySwamy |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-16 : 10:00:46
|
| 1. sort of. this setting is usually used for log shipping standby servers. msdb and master must also be in synch. see here. Replication isn't just going to start working on the development server though.2. No, you'll need to manage this yourself. This is the wrong approach in my opinion. If you're archiving data, transactional replication is a poor choice to accomplish the task. |
 |
|
|
|
|
|
SQL 2008 Replication