SQL Database Upgrade from 2011 to 2012 is failing

Versions / Builds Affected

20120717

Status

Resolved

Problem Summary

When attempting to upgrade the 2011 SQL database to 2012 a message is displayed that states failed to upgrade database

TT / JIRAID

TT123

How to Identify

The following log should be analyzed to determine if the issue described here exist. %temp%\lanss_vll_lnssinstsql.csv ***RESTORE DATABASE LNSSScanResults11 (Here we are trying to rename the copied 2011 database to LNSSScanReults11) FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\LNSSScanResults10_73E89CBF-A22E-46B7-9D65-4F1BAD16DACD.bak' WITH MOVE N'LNSSScanResults10' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\LNSSScanResults11.mdf', MOVE N'LNSSScanResults10_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\LNSSScanResults11_log.LDF', FILE = 1, REPLACE Here we can see that the rename shown above does not occur. 2012-08-08,09:14:18,854,"#00000d54","#00002480","error ","InternalExecuteSqlScriptFromCStringWithConnString COM error (911): [Source] : Microsoft OLE DB Provider for SQL Server [Description] : Database 'LNSSScanResults11' does not exist. Make sure that the name is entered correctly.

Workaround / Fix Details

Apply the patch: http://ftp.gfisoftware.com/patches/LG11/20120717/LANGUARD11_PATCH_20120827_01.zip.

Required Actions

Apply the workaround.