Determine Physical Device Name for a backupset.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » Determine Physical Device Name for a...

Determine Physical Device Name for a backupset.

Rate Topic

Display Mode

Topic Options

Author

Message

Jamie Johnson-406551

Posted Tuesday, September 30, 2008 10:14 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 09, 2012 9:26 PM
Points: 6, Visits: 161

I am running the folowing query:

SELECT TOP 1 M.physical_device_name
FROM msdb..backupset S
JOIN msdb..backupmediafamily M ON M.media_set_id=S.media_set_id
WHERE S.database_name = 'Gecko'
AND s.type = 'D'
ORDER by backup_start_date DESC

which returns the following physical_device_name: '{80F398C7-58AC-4DC6-BC15-0B2BE1A62C8E}8'

The physical address is in fact: 'E:\MSSQL\Backup\Gecko_db_200809301808.BAK'

What would this guid be pointing at?

Post #578834

Ian Scarlett

Posted Wednesday, October 01, 2008 4:26 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:12 AM
Points: 1,322, Visits: 4,400

That query should work... are you using any 3rd party tools to run the backup?

Post #578944

Jamie Johnson-406551

Posted Wednesday, October 01, 2008 4:51 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 09, 2012 9:26 PM
Points: 6, Visits: 161

The backup is run by a 'Database Maintenance Plan' (which I did not setup) with a vanilla set of parameters for a daily backup.

However, a clue to the oddity may be in the following BackupMediaFamily record for the backup:

media_set_id: 14133
family_sequence_number: 1
media_family_id: B3A6F86C-0000-0000-0000-000000000000
media_count: 1
logical_device_name: NULL
physical_device_name: 80F398C7-58AC-4DC6-BC15-0B2BE1A62C8E}8
device_type: 7
physical_block_size: 1024

I do not know what device_type: 7 is?

thanks

Post #579422

Ian Scarlett

Posted Thursday, October 02, 2008 2:50 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:12 AM
Points: 1,322, Visits: 4,400

Device type 7 is a virtual device.

Are you doing other backups (as well as via a maintenance plan) using 3rd party tools e.g. Veritas Backup Exec?

Post #579522

Jamie Johnson-406551

Posted Thursday, October 02, 2008 6:39 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 09, 2012 9:26 PM
Points: 6, Visits: 161

Thanks for that

The database is first backed up by Maintenance Plan to a physical file, and then by Backup Exec SQL Server agent. Just had to look a little further.

I now know that virtual device backups will return a guid....

This issue is now closed.

Post #580005

surma.sql

Posted Thursday, August 02, 2012 4:52 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 19, 2012 6:56 PM
Points: 104, Visits: 364

Jamie Johnson-406551 (10/2/2008)

can you please help me how to resolve this issue.

I have same problem

Please

Post #1339572

« Prev Topic | Next Topic »

Permissions