Search
-
ERASEFILES = 1 ???
I want only one copy of backups on disk but with ERASEFILES = 1, the previous night's backups are NOT deleted. I could use ERASEFILES = 23h, but I have a lot of Agent jobs to edit... In Enterprise Manager, the correlary is "remove files older than x days", which when set to 1 gives me the desired result of a single backup… -
Re: ERASEFILES = 1 ???
Are the last modified dates of the 2 backup files more than 24 hours apart? SQL Backup compares the last modified dates of the backup files to determine when to delete files, while I think EM compares the creation date. SQL Backup works this way because of an 'eccentric' design decision I made. A database backup contains… -
Re: ERASEFILES = 1 ???
I understand the reasoning behind your implementation, and I appreciate the added granularity SQL Backup provides with retention measured in hours in addition to days. However, with all due respect, I find your implementation a bit too esoteric. Since SQL Backup is replacing functionality within EM, it makes sense to me to…
3 results