In my SQLS Server 2005 log, when backups occur, I see something like:
Database backed up. Database: blahblah, creation date(time): 2011/08/11(15:49:19), pages dumped: 1, first LSN: 142:489:1, last LSN: 142:491:1,
number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{9A325509-4285-4C8A-E1B2-2F4815C4C4DF}15'}). This is an informational message only. No user action is required.
Regarding that virtual device specification, {9A325509-4285-4C8A-E1B2-2F4815C4C4DF}15'}
:
In what system table is that virtual device string? If it matters, the reason I ask is I have a query regarding latest backups and need to filter based on the virtual device.
I have looked in all of the obvious places, like:
msdb.dbo.backupmediaset
msdb.dbo.backupmediafamily
msdb.dbo.backupfile
msdb.dbo.backupfilegroup
sys.backup_devices
but no luck. If it is indeed stored somewhere, does the location change between SQL versions?
Any help appreciated.
TIA
dbaman