Red Gate forums :: View topic - GUID like entry for physical_device_name
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

GUID like entry for physical_device_name

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Rob



Joined: 26 Aug 2009
Posts: 3

PostPosted: Wed Aug 26, 2009 11:36 pm    Post subject: GUID like entry for physical_device_name Reply with quote

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?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Thu Aug 27, 2009 5:44 am    Post subject: Reply with quote

Could you please run the following:

Code:
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
Back to top
View user's profile Send private message Send e-mail
Rob



Joined: 26 Aug 2009
Posts: 3

PostPosted: Thu Aug 27, 2009 4:22 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Rob



Joined: 26 Aug 2009
Posts: 3

PostPosted: Thu Aug 27, 2009 5:09 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Thu Aug 27, 2009 5:17 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group