Re: Backups

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 14:18:28 +0100

Expiredays and retaindays are only there to not allow you to overwrite using
the INIT before a certain day. If you aren't using INIT or if you are using
NOINIT, it will always be append. And, it is all or nothing.

If you want generation handling, either use the Maint Wizard, a 3:rd party
like www.dbmaint.com or some TSQL programming to handle this (using more
than one backup device). 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"mat" <anonymous@discussions.microsoft.com> wrote in message
news:a5ce01c40a8e$5c4c13e0$a601280a@phx.gbl...
> I have created a backup schedule for all databases on a
> SQL server.  I have Created a Backup device for each db.
> and a single stored procedure that is called with database
> name, device & retain days passed as parameters. All
> Devices are network locations. I didn't want these backups
> to swallow the entire disk space so i set the retain days
> to 14. After 2 weeks i hoped that each backup would have
> been overwriten.  Well that was my logic. 2 weeks are up
> and the files created are still growing. After some
> investigation it is apparent that the expiry dates have
> been passed but the backups sets have not been
> overwritten. So much for my plan. I have now re-read BOL
> and realised that i have got my wires crossed, the entire
> media is overwriten when the expiry dates of all backups
> within have been reached.  To me this is topsy turvy, why
> would i wish to overwrite an entire backup file, maybe if
> i had taken a back up of the backup then i would wish to
> delete it. Have i yet again misunderstood BOL. What i want
> to do is maintain a dynamic history of backups. I back up
> my database to a device, this backup lasts for 2 weeks and
> then is overwriten. so the actual physical file is never
> deleted, only the contents within when the expiry date is
> reached.
>
> Help!!!!!!!
>
>

Relevant Pages

  • [UNIX] BRU Backup Program Vulnerable to Symlink Attack
    ... BRU provides fully verified backup ... The usage of insecure tmp files in some of the various shell scripts, ... which allows you to overwrite arbitrary files with 'foobar'. ...
    (Securiteam)
  • Re: NT Backup Fails to External HD - Insufficient Disk Space
    ... As I mentioned in my original post, I have selected overwrite rather than append. ... For five nights there should be about 100 to 150 gigs free after backup. ... Verify that you have full access to the working folder and there is disk space available." ...
    (microsoft.public.windows.server.sbs)
  • Re: backup
    ... enter the QUIT command at the BACKUP> prompt. ... To overwrite information in the volume header and continue ... > Request 81, ...
    (comp.os.vms)
  • Re: Hard disk overwrite danger ?
    ... One of the options during backup is whether to APPEND or OVERWRITE the ... overwrite the folder contents - including subfolders, ... It would overwrite any previous backup files created by ntbackup. ... hierarchy of the folders and files that are selected for restore, ...
    (microsoft.public.windowsxp.general)
  • Backups
    ... I have Created a Backup device for each db. ... and a single stored procedure that is called with database ... media is overwriten when the expiry dates of all backups ... would i wish to overwrite an entire backup file, ...
    (microsoft.public.sqlserver.server)