Backup Policy

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  April 29, 2009 at 5:38 am

  #155629

  We do backups through litespeed, mostley we do regular full backups and now i was asked to put 2 backup files into 1 so that we can save space on the disk but i was more inclined towards having 1 full backup set as we do full backups only once a month or once a week.

  Could some one let me know what are the pros and cons, ofcourse i am sure we are going to save space but what are the dis advantages.

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  April 29, 2009 at 5:42 am

  #985806

  Here is what i do now

  exec master..xp_backup_database @database = 'mydb', @filename = 'd:\backup\mydb_tlog_20080828.bkl', @init = 1

  which overwrites the existing backup file and if i use @init = 2 it will save old copy too having 2 backups in single file.