How can we help you today? How can we help you today?

Problem with ERASEFILES_ATSTART

Hello,
I'm using a job to backup my transaction log every 2 minutes. I want the job to erase all tranlog backups that are older than 24 hours (1 day).
I use the following syntax in my TSQL job :
master..sqlbackup '-SQL "BACKUP LOG [MAEVA3] TO DISK = ''J:\SQLBU\LOCAL\MAEVA3\TRANLOG\<AUTO>'' WITH NAME = ''CALCIUM MAEVA3 TRANLOG'', DESCRIPTION = ''Transaction Log Backup CALCIUM/MAEVA3'', COMPRESSION = 1, ERASEFILES_ATSTART =1, COPYTO=''\\ARGON\m$\SQLBU\CALCIUM\MAEVA3\TRANLOG'' " -E'

The problem is that the job erase files older than 22 hours.
For instance, today's 9:02 AM job with erase all files til yesterday 11:02 AM. I think it comes from a bug about timezones.
My SQLServer 2000 Enterprise Edition runs on Windows Server 2003 EE.
The W2S2k3 is set on GMT+1.
Thanks for reading this post and helping solve the problem.

Stephane
slhuillier.om
0

Comments

3 comments

Sort by
  • petey
    Request for an updated version from support.
    petey
    0
  • slhuillier.om
    Sorry, but may i ask you how to request the update version ? :oops:
    slhuillier.om
    0
  • petey
    Send a request to support@red-gate.com.
    petey
    0

Add comment

Please sign in to leave a comment.