June 12, 2006 at 2:06 pm
Has anyone seen this before?
Every Sunday morning (a different time each week) there is a full backup created for every database on the server. The backup is not a scheduled backup from any maintenance plan or SQL Agent job. The backup set is unrestorable and has a strange name in the format of 'DBNAME_00_12c95fb7_399d_41ce_9a0d_b5728b6a00ba_'
Because this backup is listed as the last full backup and will not restore, it is causing a problem with our disaster recovery plans.
Does anyone know how a backup record like this can get created, and/or how to find the source. The backups are listed in the backupsets table in msdb - are there other system tables that may hold some clues as to the source of these backups?
Any help or direction would be appreciated.
Thanks
Tim
June 13, 2006 at 5:57 am
Check your server scheduled jobs. My guess is that someone created a windows scheduled job to do this.
June 13, 2006 at 6:26 am
Also look at tape backups.......is Veritas Backup Exec being used? BE10d has the ability to backup files to disk and with the Agent for SQL Server, it could create database backups.
Find out what time the backup runs, then sit down with your sysadmin, network admin, and anyother admin you might have and discuss it with them.
-SQLBill
June 13, 2006 at 11:59 am
Thanks SQLBill. That's exactly what I did and discovered that the Veritas backup job at our data centre was hitting all of the SQL Server instances on our domain.
Tim
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply