August 21, 2013

SQL Restore fails to load file

This is pretty rare.  SQL 2008 R2 installed then uninstalled.  SQL 2005 installed.  Red-Gate's SQL Backup installed and try to do a database restore fails with the error: "SQL Backup exit code: 1010, SQL error code: 3201".

It's because the sqlvdi.dll file from 2008 is still on the server.

Use the SQL Backup Simulator tool from MSDN to determine what versions are on the server and what version is in memory.  To replace the incorrect versions, stop SQL Services (if in memory) and copy/paste from a known good server (if available).  Register the dll using regsvr32.  Backups are back in business!