SQLBOT (2/10/2010)
How often are tape backups running?
Actually, this is the "root cause" of the problem. [GRUMBLE]It depends on who you ask.[/GRUMBLE] This is a locked down shop in which the DBAs do not have access to the backup configuration. We are told that backups occur every day. However, when I need to chase down some autodeleted files, the ones I need never made it to the backup tape. "Oh, there was an issue..." :crazy: I would like to make enough rollover files to survive a few days of backup "issues." :satisfied: And, yes, this sadly impacts the SQL Server backups that we write to disk.