Database size issues/backup restore procedure

• Robert Williamson

  Newbie

  Points: 1

  More actions

  February 16, 2006 at 3:56 pm

  #166986

  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

• allen davidson

  SSCertifiable

  Points: 7042

  More actions

  February 17, 2006 at 2:04 am

  #621570

  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