Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vanbasten
Starting Member
7 Posts |
 Posted - 2012-07-10 : 19:03:31
|
| We are running daily full backup and hourly tlog backup on this 10-databases 2K8 Standard SQL instance . The two backups are setup through Maintenance plans and scheduled/executed through two Jobs in SQL Agent. Those two backups are working fine.However, I noticed that 1 of the 10 databases have an extra differential backup that runs periodically. This differential backup is not part of the jobs or maintenance plan that we setup. I am trying to get rid of this job but I don't know where to look. The only information I have is through the logs it shows:2012-07-09 23:15:11.80 Backup Database differential changes were backed up. Database: db1, creation date(time): 2012/05/16(10:56:18), pages dumped: 266, first LSN: 35609:369:103, last LSN: 35609:381:1, full backup LSN: 35609:135:36, number of dump devices: 1, device information: (FILE=11, TYPE=DISK: {'E:\MSSQLSERVER INSTANCE\Backup\Db1AutomatedBackup2012-07-09.bak'}). This is an informational message. No user action is required.We did copy this db from a Vendor (originally a 2K5 Express db) so we are not sure if any config was copied over. Any help is appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2012-07-10 : 23:59:37
|
A RESTORE HEADERONLY will tell you the user name that performed the backup operation, and name of the computer that performed the backup operation.RESTORE HEADERONLYFROM DISK='E:\MSSQLSERVER INSTANCE\Backup\Db1AutomatedBackup2012-07-09.bak' It is possible that the backup is scheduled on some other computer using the windows scheduler or some other type of job scheduler, and that would help you track that down.CODO ERGO SUM |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-07-11 : 13:41:45
|
| You can also pick up some clues from the msdb.dbo.backupset table.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
vanbasten
Starting Member
7 Posts |
Posted - 2012-07-11 : 17:40:43
|
| I tired both the restore headeronly command and looked at the msdb.backupset table. Both MachineName and ServerName show the name of the local server. The UserName shows a sql login that maps to, and have db_owner role to this database "db1". So basically the differential backup job is being run locally on the db server by a sql login every 2 hours. Is there anything else I can check to track down this job? Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-07-12 : 01:56:07
|
| If there are no references on the Windows Scheduler or SQL Agent, check with another Adminmistrator , that some centralised scheduler is not running , such as Autosys. That could be triggering , another script on the serverJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
non-scheduled diffiential backup job