troubleshooting Question

How to check if SQL server database is being backed up by SQL management studio ?

Avatar of Senior IT System Engineer
Senior IT System EngineerFlag for Australia asked on
PowershellDatabases* T-SQLMicrosoft SQL ServerScripting Languages
13 Comments2 Solutions1134 ViewsLast Modified:
Hi All SQL Server & scripting experts,

I've got multiple different version of SQL Server Database running from 2008 R2 up to 2014 edition.

Can anyone here please share the script (T-SQL or PowerShell) to list all SQL Backup job that is currently setup or configured to backup the Database on each database server?

I need to know if there is any backup job has been set and where it is dumping it's database into ?
Because sometimes I've found out that the D:\ drive is full due to the SQL backup dumping large.BAK file into the same drive as the SQL database .MDF running.

Thanks in advance.
ASKER CERTIFIED SOLUTION
pcelba

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros