-
Title
INTERNAL Restoring MSSQL 2000 to MSSQL 2005 -
Description
Date: MAR-2007
NV Version: 7.4.x
OS Version: Windows
Application version: MSSQL 2000 / MSSQL 2005
Plugin version: 4.1+
INTERNAL ONLY
Description: Can you do it? Yes. Is it supported? No.
Symptoms:
Restore 2000 backup to 2005 - same as you would 2000 to 2000.
It works - MSSQL does the upgrade on the fly. In the bin log you will see:
Job Message 2007/03/23 10:53:48 151 Media nv_kerri (nv_kerri: n:\VDL\VDL1) Drive 'DRIVE 1:nv_kerri' has completed its transfer
Job Message 2007/03/23 10:53:50 151 Data Plugin KJW2K3 [Microsoft][ODBC SQL Server Driver][SQL Server]Processed 1 pages for database 'fred2', file 'kerri_Log' on file 1.
Job Message 2007/03/23 10:53:52 151 Data Plugin KJW2K3 [Microsoft][ODBC SQL Server Driver][SQL Server]Converting database 'fred2' from version 539 to the current version 611.
Job Message 2007/03/23 10:53:52 151 Data Plugin KJW2K3 [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'fred2' ru
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.