August 9, 2006 at 12:20 pm
My SQL 2005 server is showing in the logs that nightly backups being run on all databases, this would be a good thing if I had coresponding maintenance plans or agent jobs that are scheduling this. I have no idea what is triggering these backups or even the details of where they are being written to.
Does anyone have any idea where these are coming from and how can I control them?
August 9, 2006 at 12:33 pm
You might want to run profiler on the database server overnight and then search for BACKUP DATABASE or BACKUP LOG statements... That should give you some more information.
August 10, 2006 at 11:54 am
To quickly see what's going on you could use a query like this from query analyzer on one of the databases in question...check to see if there are any stored procs or triggers running backups. We have procs and triggers that backup db's from time to time.
select * from sysobjects where id in (select id from syscomments where text like '%backup%database%')
Also run this to see if the backups are from a maintenance plan:
select * from msdb.dbo.sysdbmaintplan_history where database_name='xyz'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply