Can anyone tell me why the system database files are returned along with all backup devices when I run sp_helpdevice? I am expecting to see the backup devices that I created but was a bit confused by the system database files.
See sp_helpdevice entry in BOL for explanation. When I need info on backup devices I query directly sysdevices system table for records with status 16. It's not recommended but works for me.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply