Friday, February 24, 2012

how to find backup batches?

how and where to check if any backup batch is active on my sql server database?

What version of SQL Server?

If your using 2005 and

if by “backup batch is active” you mean a backup currently running.

in Object Explorer /Management look at the Activity Monitor

or

ff the backup is part of a job goto SQL Server Agent / Jobs /Job Activity Monitor

No comments:

Post a Comment