February 16, 2006 at 3:56 pm
Hi All,
I am new to the site so if my questions can be answered elsewhere please let me know.
My problem is that I have an SQL database that receives a large amount of data everyday. Currently the database size is "Unrestricted" so it will continue to grow. What I want to do is have a fixed amount of data available in the database and have a backup of old data. Also I need an easy way to restore backed up data to the database.
Any ideas on how to accomplish something like this?
I was think a job to remove old rows and store in a text file. These rows can be inserted again at anytime. Is this a logical approach?
Regards,
RobW
February 17, 2006 at 2:04 am
Hi Robert,
My approach would be to datetime stamp everything on load (this can be handy anyway) and then bcp out to a text file and archive on DVD.
David Poole had an article published yesterday on this very topic http://www.sqlservercentral.com/columnists/dpoole/dataarchivingproblemsandsolutions.asp
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply