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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-06 : 12:24:03
|
| David writes "On SQL2000...We have transactional replication setup to replicate data from production across to a reporting server.We want to ARCHIVE production, but don't want the ARCHIVE duplicated on the reporting server.Does anyone know of a way that the reporting server can be stopped from replicating these changes, and continue to hold the FULL history of the database?" |
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-07 : 03:44:09
|
| 1.Backup the logs on the production server and restore them on the reporting server(if replication is done asyncronous) | disconnect reporting server (if replication is done syncronous)2.Do the archiving.3.Backup and purge the transaction logs on the production server.4.Toss the backups. |
 |
|
|
|
|
|
NOT replicate Data Archive...