Geek asks and answers

How to convert the SQL Server 2008 .mdf file to SQL Server 2012?

Do I need to convert a file DATABASE.MDFfrom SQL Server 2008 to SQL Server 2012?

The Sales database cannot be updated because its non-release version (539) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must recreate the database.
Failed to open the new Sales database. CREATE DATABASE aborted. (Microsoft SQL Server, Error: 950)

+5
source share
2 answers

Just attach it and it will be updated. If you don't have an LDF file (and why don't you have an LDF file?), You may need to use:

CREATE DATABASE [DatabaseName] ON 
    (FILENAME = N'Drive:\path\file.mdf')
    FOR ATTACH_REBUILD_LOG;

, ...

  • , .mdf, , . SQL Server, , ( .mdf). , .mdf, . .mdf , :

. "..._ log.LDF" .
, .
Msg 1813, 16, 2, 1
"DatabaseName". CREATE DATABASE .

  • 80, ​​ 90. , - , , *=/=* .
  • > 10 , Express (, , LocalDB, ), (, , , ?.
  • , 2008 Enterprise/Developer, , -...
  • , 2008, 2000 . SQL Server 2012. SQL Server 2005, 2008 2008 R2, , SQL Server 2012.

FWIW, BACKUP/RESTORE ( , , - , - , ). - .

+15

, , . 539 SQL Server - 2008, SQL Server 2000. . : SQL Server: ?

, / SQL Server 2000 db SQL Server 2012. , , SQL Server 2008 R2, SQL Server 2012. .

+2

More articles:


All Articles