sql 6.5 backup question

• Richie Dennehy

  Newbie

  Points: 1

  More actions

  November 30, 2005 at 5:11 am

  #111406

  I've only worked with sql 7.0 and later but now i have an issue with a sql6.5 backup. I'm not sure exactly what im doing and this may be a stupid question.

  Basically we have a database which is being backed up using the following command:

  DUMP DATABASE <databasename> to <databasenamebackup> WITH NOUNLOAD, STATS=10, NOINIT, NOSKIP

  The thing is is that the backup device file is now 14 GB - even though the database itself is only about 200 MB. The disk is now out of space and the backup isnt working. The database has been appended to the backup device file for over a year. I want to change this so that the backup overwrites the previous days backup. What would i have to change in the above script to do this?

  Thanks a lot

  Richie Dennehy

• Sameer Raval

  Hall of Fame

  Points: 3214

  More actions

  November 30, 2005 at 3:05 pm

  #606903

  Instead of NoINIT try INIT option

  this will initialize the backup file everytime it writes to backup file.

  DUMP DATABASE <databasename> to <databasenamebackup> WITH NOUNLOAD, STATS=10, INIT, NOSKIP

  Kindest Regards,

  Sameer Raval [Sql Server DBA]
  Geico Insurance
  RavalSameer@hotmail.com