Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    17

    Unanswered: Differential Backup Files

    When a new scheduled job is created for a Differential backup, the file specified in the Destination folder is automatically created by SQL Server. After the first time the job runs, is there a way to configure SQL Server to give each Differential file a unique name, including the timestamp (i.e. similar to Full Backup jobs)? I noticed my only options are 'Append to File" and "Overwrite Existing File." If I choose to enable "Backup Set Expiration," the backup job will not run, because it wants to append/overwrite the filename specified.

  2. #2
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    pretty easy to do via T-SQL statement. The following script creates a backup with date and hour as timestamp in file name.

    declare @hour varchar(2), @date varchar(8)
    set @hour = substring(convert(char(2), getdate(), 108), 1, 2)
    set @date = convert(varchar(8), getdate(), 112)
    exec ('use master backup database xxx to disk = ''D:\backup\xxx_db_' + @date + @hour + '.bak '' with init')

Posting Permissions

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