Lowell, excellent. That was exactly what I was looking for. Thanks for your time.

noeld, excellent. This works perfectly. I'm sure I'll get plenty of use out of this type of conversion in the future!

Ryan

Thanks, that worked! I was using the Backupfile table earlier but I no longer need it.

Thanks for your reply. I combined my script with yours to get the script below. Selecting backup_set_size I can now see that there are definitely duplicates. Any...

I modified the script to select the backup_set_id so I can now see that there are definitely duplicates. Any additional feedback on this script would be greatly appreciated. ...

Thanks for your reply.

Yes, there is an entry for both the Log and the DB and they are listed in the Type column as 'L' or 'D' respectively. The...

You could also do something like:

SELECT * FROM master.dbo.sysprocesses

This won't give you everything that sp_who2 gives you but might give you what you need. However, when I run sp_who2...

Many thanks for your post.  I will check out the links you provided.