Home Forums SQL Server 2005 Administering How to Reverse Engineer the Current Settings for sp_trace_create RE: How to Reverse Engineer the Current Settings for sp_trace_create

  • 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.