Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

Checking my Native backup this morning something wierd happened. I will describe the problem here.

1) The msdb table backup set shows me the backup was done successfully.

2) The errorlog shows me that the backup was done successfully.

3) The job history doesn't show any entry, even it is successfully or error.

4) Checking the backup media family table the physical device name column shows me something like this: {F2F1E11C-589A-4AAE-8880-0120D8D1998D}1 and other days it shows me the right directory of my backups.

4) The DPM also do system state and database backup after the SQL Server Backup and runs well.

Well.. if anyone need more informations, please let me know.

Thanks. Marcos Freccia @SqlFreccia

share|improve this question
2  
The physical device name of a GUID means the backup didn't really finish successfully, OR that it's a device-based backup (like tape or DPM). – Brent Ozar Jul 4 '12 at 11:59
So, I assume when a DPM backup finish it also insert a record in msdb backups table? – Marcos Freccia Jul 4 '12 at 12:02
Yeah, DPM backups (as long as they're SQL ones) will also be reflected in MSDB. If you do a system-state-only backup then it won't. – Brent Ozar Jul 4 '12 at 12:12

1 Answer

up vote 1 down vote

This can be VSS based DPM backups. Do you also have info in the Errorlog about "I/O Frozen for database xxx" and "I/O thawed for database xxx" ? That is sign of VSS (Snapshot) backups. If you rely on that kind of backups you should (as always) ensure that you can restore the backups, and you should pay special attention to Log backups.

share|improve this answer
Yep.. there are these entries in errorlog, but the DPM backup is 2 or 3 hours after the SQL Backup. – Marcos Freccia Jul 5 '12 at 11:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.