Friday, June 05, 2009

Virtual PC and SQL Database Restore

A coworker ran into the problem of not being able to restore a SQL database to a vpc machine. The Name of the backup would read in as "*** INCOMPLETE ***". The backup file was fairly large (about 6GB). A small database restore worked, but not the large file.

Anyways, the exact problem and simple solution to the problem can be found on Stuart Cox's blog:
http://techpunch.wordpress.com/2008/10/16/virtual-pc-sql-server-restore-database-failure-media-family-incorrectly-formed/

I need to start structuring posts like Stuart Cox, clearly laying out Problem / Resolution, because that makes things clear to understand.

No comments: