Thursday, April 2, 2009
Working on a database project today I got the latest drop from a co-worker to test on our deployment machine. The process had gone on without a hitch for the past few months but today the SQL 2005 database backup file he gave me would not restore on the deployment machine...gave an error during the restore saying it was "INCOMPLETE". A quick check of SQL Server versions using MS KB 321185 showed us that he was on SQL 2005 SP3 and I was on SQL 2005 SP2. Thankfully that 2 minutes worth of checking saved lots of time trying to hunt down a problem that wasn't really there. Hopefully this posted here will save someone else time and trouble too.