GUID like entry for physical_device_name

Forum for users of Redgate's SQL Backup tool

GUID like entry for physical_device_name

Postby Rob » Wed Aug 26, 2009 11:36 pm

Running Redgate backup 5.2...

When querying msdb.dbo.backupmediafamily.physical_device_name I find entries that are guid-Like ... example:

{A2E046C7-CCD6-4875-9CA4-69EF16033133}3

Any ideas why this is happening?
Rob
 
Posts: 3
Joined: Wed Aug 26, 2009 9:06 pm

Postby petey » Thu Aug 27, 2009 5:44 am

Could you please run the following:

Code: Select all
SELECT a.physical_device_name, a.logical_device_name,  a.backup_set_uuid, a.device_type, b.backup_start_date, b.backup_finish_date
FROM msdb..backupmediafamily a
INNER JOIN msdb..backupset b ON a.media_set_id = b.media_set_id

Where the physical_device_name are GUID-like, do the logical_device_name indicate that they are SQL Backup backups? If they are, could you please use the backup_set_uuid and backup_finish_date values, and try locating the SQL Backup log file for that backup? By default, the log files are stored in the 'C:\\Documents and Settings\\All Users\\Application Data\\Red Gate\\SQL Backup\\Log\\<instance name>' folder.

Are there any errors recorded in the log file?

Thanks.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2301
Joined: Sun Apr 24, 2005 12:34 pm

Postby Rob » Thu Aug 27, 2009 4:22 pm

I ran the code and get an error that a.backup_set_uuid does not exist. I removed that column and get results.

I checked the logs and there are no errors. The logs match entries that have proper physical device names. The others are odd:

Sample:
physical_device_name: {1EC50781-9173-4658-A83A-53049FDB244A}8
logical_device_name: null
device_type: 7
backup_start_date:8/26/09 6:45 PM
backup_finish_date : 8/26/09 6:45 PM

Not sure what to make of it.
Rob
 
Posts: 3
Joined: Wed Aug 26, 2009 9:06 pm

Postby Rob » Thu Aug 27, 2009 5:09 pm

I have found the mysterious culprit making backups. These are VM machines and a vmware server back up occurs at the time of the entry. It uses the sql server vss writer service and actually makes a sql server backup at that time of the server backup. I would like to turn off the vss writer service... will this affect redgate backups?
Rob
 
Posts: 3
Joined: Wed Aug 26, 2009 9:06 pm

Postby petey » Thu Aug 27, 2009 5:17 pm

Sorry, should've been b.backup_set_uuid.

AFAIK, SQL Backup does not use the VSS writer service.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2301
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests