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 |
|
kvt.aravind
Starting Member
24 Posts |
 Posted - 2010-09-10 : 02:25:21
|
| hi all,I have to create DBarchive for my production db. The dbarchive should contains only Four tables from production DB such that when the recordsfrom these tables in production DB are deleted these records should moved to the tables in DBArchive.Kindly give the script for creating DBARCHIVE from productionAravind.T |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-10 : 03:41:14
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=170215 has code for storing Changes (and Deletions) to a record. You could change that to just Deletions and store them in a table in another database. |
 |
|
|
|
|
|
Archive Database