troubleshooting Question

SQL 2005 - msdb.dbo.BACKUPSET

Avatar of dastaub
dastaubFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
2 Comments1 Solution629 ViewsLast Modified:
If I run SELECT * FROM msdb.dbo.BACKUPSET  it includes the name of the backup set.  That name is the name assigned with the parameter of 'name' in the t-sql backup command.

Is there another  SQL table that contains the name of the backup file that shows up in Windows explorer?
BACKUP LOG BACKUPSAMPLE TO DISK = 'F:\BACKUPSAMPLE_LOG4.BAK' with name = 'backupsample log backup 128'

I am interested in 'BACKUPSAMPLE_LOG4.BAK'  and if possible, the location of the backup?

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

Join our community to see this answer!
Unlock 1 Answer and 2 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 1 Answer and 2 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