DB Backup plan to be made as append or overwrite

• dakshinamurthy-655138

  SSCertifiable

  Points: 5172

  More actions

  March 21, 2008 at 6:16 am

  #180335

  Hi,

  I am using SQL Server 2005, and using Maintenance plan to take the DB Backup on daily basis so please let me know which one is effecient should i use Append or Overwrite option.

  Please

  DB Backup plan to be made as append or overwrite

• GSquared

  SSC Guru

  Points: 260824

  More actions

  March 21, 2008 at 9:05 am

  #792514

  This is a duplicate post.

  http://www.sqlservercentral.com/Forums/Topic472721-149-1.aspx

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  March 21, 2008 at 9:23 am

  #792529

  Please do not cross post as we scan all forums.