Problem with ERASEFILES_ATSTART
slhuillier.om
Posts: 7
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
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
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8