I have a need to only keep 3 mos of data in a production DB (SQL7) but all
the previous data needs to go into a separate "history" DB. Every month I
will need to push the oldest month of data from the production DB to the
history DB. Initially I guess I could just duplicate the DB and purge data
in the production DB.
Im looking for recommendations on how to push one months data efficiently
from DB to DB...? Can an UPDATE work cross DB?
Also, when I do a purge (DELETE) how do I keep the transaction log from
growing out of control...?
-Adrian
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
