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 |
|
Gothic
Starting Member
2 Posts |
 Posted - 2008-09-10 : 08:33:13
|
| Hi experts! A short description of my issue:Today we have two diffrent databases with the same structure on one table. We would like to have a common table as a backup for these two tables. Since we constantly delete data older than 1 month in both databases we need the backup to hold older data in case we need to restore data older than one month. I was planing to use Replication but that is more like mirroring (if I delete rows in the publisher it will also delete the rows in the subscriber). I would like it to be more "one way", as for every new insert push it to the subcriber and for delete statment do nothing. Is linked servers and insert trigger the only way to go? |
|
|
Gothic
Starting Member
2 Posts |
Posted - 2008-09-10 : 09:14:57
|
| I think I found what I was looking for. At the Publisher I could disable the Delete-statment.Thanks anyway |
 |
|
|
|
|
|
Bakup for common data in diffrent databases