Hi everyone, I have a few databases in SQL Server that are starting to get a little big and want to archive some of the older stuff in there. Does anyone know of a good way to automate this? Does SQL Server have some built in capabilities for handling something like that. Right now my thoughts were to copy the tables over to an Archive Database then delete the newer records and then in the Live Database delete the older records that I moved to the Archive database. I would like to have it so if a record is more than 2 years old automatically move to the archive db. I would appreciate it if someone has some better ideas.
Thanks, Ben ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
