ERASEFILESDAYS number of days limits
owenh
Posts: 25
I was setting up a series of monthly backup schedules, where I will on the last day of the month, create a full backup to a monthly directory and then keep a "rolling" year's worth of history backups for reference purposes.
After setting the ERASEFILESDAYS parameter to 365 for a years worth of files, I continued to get Syntax errors.
Here is trhe command that was issued and the results:
-SQL " BACKUP DATABASE [Master] TO DISK='D:\SQLBACKUPS\Default\MonthlyBackups\Master\Master_db_20050819082633403.sqb' WITH NAME='DATABASE Master, 2005-08-19 08:26:33.403', DESCRIPTION='Backup on 08/19/2005 08:26:33 Database: Master Instance: (local) Server: HOU-SQL01', VERIFY, MAILTO='owenh@amerexenergy.com', MAILTO_ONERROR='owenh@amerexenergy.com', ERASEFILES=365, COMPRESSION=3 " -E'
Output from SQL Backup (3.2.0)
SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
Serial number: 010-001-025995-5465
Syntax error: 365 after =
After playing with this for a while, trying some different numbers of days, it appeatrs that the command has an upper limit of 255 days. Is this a limit of hte OSQL interaction? Please veriffy. And, more importantly, will this be addressed in a future release, which I understand will be breaking hte dependance of the OSQL Utility?
Thanks.
After setting the ERASEFILESDAYS parameter to 365 for a years worth of files, I continued to get Syntax errors.
Here is trhe command that was issued and the results:
-SQL " BACKUP DATABASE [Master] TO DISK='D:\SQLBACKUPS\Default\MonthlyBackups\Master\Master_db_20050819082633403.sqb' WITH NAME='DATABASE Master, 2005-08-19 08:26:33.403', DESCRIPTION='Backup on 08/19/2005 08:26:33 Database: Master Instance: (local) Server: HOU-SQL01', VERIFY, MAILTO='owenh@amerexenergy.com', MAILTO_ONERROR='owenh@amerexenergy.com', ERASEFILES=365, COMPRESSION=3 " -E'
Output from SQL Backup (3.2.0)
SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
Serial number: 010-001-025995-5465
Syntax error: 365 after =
After playing with this for a while, trying some different numbers of days, it appeatrs that the command has an upper limit of 255 days. Is this a limit of hte OSQL interaction? Please veriffy. And, more importantly, will this be addressed in a future release, which I understand will be breaking hte dependance of the OSQL Utility?
Thanks.
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