Hello,
I'm the SQL DBA and one of my responsibilities is verifying the SQL backup devices (that I have configured). We're running SQL 2005.
One method I've been using is to run a query similiar to this in the Management Studio's query analyzer:
restore filelistonly from
disk='\\our-server\our_folder\backup_device.bak'
The result display for some of the backup devices shows the wrong PhysicalName. The name is actually a different database than what I expect.
However, if I inspect the backup device, I see a different result. I right-click on the backup device and choose 'properties'. I move the cursor to 'media contents'. I look in the database tab, and the database is correct.
Does anyone know why the PhysicalName for a backup device is not pointing to the correct database (after running the 'restore filelistonly' command)? Also, does anyone have any advice to offer about verifying backup devices?
thanks,
I'm the SQL DBA and one of my responsibilities is verifying the SQL backup devices (that I have configured). We're running SQL 2005.
One method I've been using is to run a query similiar to this in the Management Studio's query analyzer:
restore filelistonly from
disk='\\our-server\our_folder\backup_device.bak'
The result display for some of the backup devices shows the wrong PhysicalName. The name is actually a different database than what I expect.
However, if I inspect the backup device, I see a different result. I right-click on the backup device and choose 'properties'. I move the cursor to 'media contents'. I look in the database tab, and the database is correct.
Does anyone know why the PhysicalName for a backup device is not pointing to the correct database (after running the 'restore filelistonly' command)? Also, does anyone have any advice to offer about verifying backup devices?
thanks,