Results 1 to 2 of 2

Thread: Transaction Log backups with maint wizard - overwrite

  1. 07-03-2006, 03:44 PM #1
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261

    Transaction Log backups with maint wizard - overwrite

    Using sql 2005, trying to setup maint plan to backup user db transaction logs. I know how to drop and drag, but unless you do individual, I see no way to tell the trans log backup to overwrite the backup files. Append is only choice
    Reply With Quote Reply With Quote
  2. 07-04-2006, 05:48 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Yes you can, but not suppose to overwrite log backup file between full backups since you need them for point of time recovery.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules