So I've had a case open with Microsoft since October concerning SQL databases that I cannot restore from DPM unless I run a consistency check on them first. Today, it seems they assigned to me yet ...

You can save a backup of your MS SQL databases to a single file on your hard drive. These backup files have names ending with the ".bak" file extension, and you use them to restore database backups ...