Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Determine Physical Device Name for a backupset. Expand / Collapse
Author
Message
Posted Tuesday, September 30, 2008 10:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 17, 2014 11:01 PM
Points: 6, Visits: 180
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
Posted Wednesday, October 1, 2008 4:26 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 9:19 AM
Points: 1,307, Visits: 4,508
That query should work... are you using any 3rd party tools to run the backup?


Post #578944
Posted Wednesday, October 1, 2008 4:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 17, 2014 11:01 PM
Points: 6, Visits: 180
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
Posted Thursday, October 2, 2008 2:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 9:19 AM
Points: 1,307, Visits: 4,508
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
Posted Thursday, October 2, 2008 6:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 17, 2014 11:01 PM
Points: 6, Visits: 180
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
Posted Thursday, August 2, 2012 4:52 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 19, 2012 6:56 PM
Points: 104, Visits: 364
Jamie Johnson-406551 (10/2/2008)
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.


can you please help me how to resolve this issue.

I have same problem

Please

Post #1339572
Posted Wednesday, September 17, 2014 3:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 4, Visits: 58
I encoutered same problem in jobs using maintenance plans with standard backup tasks.Resave maintenance plans solved the problem.
Post #1614344
Posted Wednesday, September 17, 2014 8:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 4, Visits: 58
I encountered same problem. The rows in msdb.dbo.backupmediafamily with
physical_device_name in format '{76F.........}9} results of periodic backups databases by VMReplicator . in error log of instance you may find :
Database backed up: Database .... device informationFILE=1,TYPE=VIRTUAL_DEVICE:{'{76F.......}9'}) .Solution probably is ignore rows with device_type=7 in msdb.dbo.backupmediafamily when you
look for "last" local backup.
Post #1614471
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse