December 17, 2014 at 7:24 am
Hi Team,
We configured jobs to run everyday on F drive .
I am seeing some backups in default location for few databases but i am not seen any jobs or maintenance plan for those backups ?
Anyone help me on this ?
Thanks,
Lavanya
December 17, 2014 at 7:34 am
Someone(s) ran backups manually?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2014 at 8:29 am
Check the error log. You can see when backups were fired off there. I think, but would have to look it up to be sure, it's also in the system_health extended event session (but I could be wrong on that).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 18, 2014 at 1:19 am
Its not manually ..it semms to be automated backup jobs ..
December 18, 2014 at 1:42 am
Via windows scheduler? Via an application?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2014 at 1:44 am
In the errorlog i am not seen anything new ...3 instances in same machine ..centralized management
December 18, 2014 at 3:21 am
Its not windows scheduler but it might be application .is it possible to find from which application they are running jobs??
December 18, 2014 at 3:29 am
Grant Fritchey (12/17/2014)
Check the error log. You can see when backups were fired off there.
Error log will also tell you the login name used.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply