What are the challenges you face when working across database platforms? Take the survey
Options

Problem with ERASEFILES_ATSTART

slhuillier.omslhuillier.om Posts: 7
edited September 30, 2005 5:51AM in SQL Backup Previous Versions
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

Comments

Sign In or Register to comment.