Error 948 Sql Server 2008
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring error 948 in sql server 2008 r2 developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Sql Server Error 948 Version 661
x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; sql server error 948 version 706 it only takes a minute: Sign up SQL Server: Attach incorrect version 661 up vote 53 down vote favorite 10 When trying to attach a database file to: Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 the database cannot be opened because it is version 661 this server supports version 655 and earlier 19:43:16
Sql Server Version 706
–Joe Stefanelli Nov 23 '10 at 15:35 1 I have installed SQL Server 2008.. but i got this error.The database 'Databasename' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported. Could not open new database 'Databasename'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948) . How to solve this? –Prince Antony G Jun 23 '12 at 7:18 add a comment| 2 Answers 2 active oldest votes up vote 71 down vote accepted SQL Server 2008 databases are version 655. SQL Server 2008 R2 databases are 661. You are trying to attach an 2008 R2 database (v. 661) to an 2008 instance and this is not supported. Once the database has been upgraded to an 2008 R2 version, it cannot be downgraded. You'll have to either upgrade your 2008 SP2 instance to R2, or you have to copy out the data in that database into an 2008 database (eg using the data migration wizard, or something equivalent). The message is misleading, to say the least, it says 662 because SQL Server 2008 SP2 does support 662 as a database version, this is when 15000 partitions are enabled in the database, see Support for 15000 Partitions.docx. Enabling the support bumps the DB version to 662, disabling it moves it back to 655. But SQL Server 2008 SP2 does not support 661 (the R2 ve
SERVER - Fix Error - 948 A downgrade path is not supported. The database cannot be opened because it is version. June 25, 2016Pinal DaveSQL3 commentsThese past weeks the number of errors I have been getting when attaching a database has been far too many. But the sql server error 948 version 655 best part of this learning experience is that I get to write about them sql server 2008 r2 version 661 download one after another. There are no right or wrong answers sometimes, but am learning every time. Here is an error which is
The Database Cannot Be Opened Because It Is Version 661 This Server Supports Version 612 And Earlier
related to a downgrade path not supported.Fix Error 948 - A Downgrade path is not supportedHere is the error I received while I was trying to attach database using below command:USE [master] GO CREATE DATABASE http://stackoverflow.com/questions/4257684/sql-server-attach-incorrect-version-661 [SQLAuthority] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2016\MSSQL\DATA\SQLAuthority.mdf' ), ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2016\MSSQL\DATA\SQLAuthority_log.ldf' ) FOR ATTACH GOError message: Msg 1813, Level 16, State 2, Line 3 Could not open new database ‘SQLAuthority'. CREATE DATABASE is aborted. Msg 948, Level 20, State 1, Line 3 The database ‘SQLAuthority' cannot be opened because it is version 852. This server supports version 782 and earlier. A downgrade path is not supported. http://blog.sqlauthority.com/2016/06/25/sql-server-fix-error-948-downgrade-path-not-supported/ The second part of the message was strange and was the first time I was seeing. I found a command on the internet to read MDF file version:DBCC CHECKPRIMARYFILE('C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2016\MSSQL\DATA\SQLAuthority.mdf',2)So, we know that version is 802 which is for SQL Server 2016. When I ran select @@version on my server I found that I was trying to attach it to lower versions of SQL.In short, this error is expected when we try to attach file from higher version of SQL to lower version of SQL. We cannot attach/detach or backup/restore a database from a newer version of SQL Server down to an older version - the internal file structures are just too different to support backwards compatibility.Here is what I was able to find on the internet.SQL Server VersionInternal Database VersionSQL Server 2016852SQL Server 2014782SQL Server 2012706SQL Server 2008 R2660/661SQL Server 2008655SQL Server 2005611/612SQL Server 2000539SQL Server 7515Do you know the steps to move to older version? What have you done before for such errors? Do feel free to share with all via the comments section below.Reference: Pinal Dave (http://blog.SQLAuthority.com) Tags: SQL Error Messages, SQL Scripts, SQL Server, SQL Server Installation218Related Articles SQL SERVER - Outer Join Not Allowed in Indexed Views June 29, 2010Pinal Dave SQL SERVER - When Are
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ https://social.msdn.microsoft.com/Forums/sqlserver/en-US/496fc77c-3d37-43ba-b115-f8f179568b1d/sql-server-management-studio-2012-error-948?forum=sqlexpress Search related threads Remove From My Forums Answered by: SQL Server Management Studio 2012 Error 948 SQL Server > SQL https://forums.asp.net/t/1688169.aspx?Error+948+version+error Server Express Question 0 Sign in to vote Hello I get the following error when trying to attach a database: TITLE: sql server Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'WLKCNU11216XJ\SQLEXPRESS'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The database 'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ADVENTUREWORKS2012_DATA.MDF' cannot be opened because sql server 2008 it is version 706. This server supports version 661 and earlier. A downgrade path is not supported. Could not open new database 'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ADVENTUREWORKS2012_DATA.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ I suspect the database has been developed in SQL 2012, so I've ran SELECT @@VERSION in my version of SQL 2012, which returns: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/SQL Server, SQL Server Express, and SQL Compact Edition/Error 948 version error Error 948 version error [Answered]RSS 5 replies Last post Jun 15, 2011 03:27 AM by kilofafeure ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply kilofafeure Member 233 Points 769 Posts Error 948 version error Jun 09, 2011 05:14 AM|kilofafeure|LINK Hi, I'm obtainning this error and I don't know how to solve it. It's a problem of versions but I don't understand why and how to solve it. I've been looking this links but I don't understand what to do. http://msdn.microsoft.com/es-es/library/bb326472.aspx http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/9a6cf067-6a6b-48f0-bda4-fc7f013c481f http://stackoverflow.com/questions/4257684/sql-server-attach-incorrent-version-661 The error appears when I try to attach a database since SQL Server Management Studio. Appears a message saying that can open the data base on version 661. The server it's compatible with 662 versions and earlier. The version of my .mdf (visual studio): Microsoft SQL Server 2008 R2 (RTM) 10.50.1600.1 The version fo my SQLSManagement: Microsoft SQL Server 2008 (SP2) 10.0.4000.0 In this page there are builds to "repair" SQL, the problem I've is that I don't know what to choose: http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx Thanks Ever than a programmer makes an extra hour god kills a kitten Reply TabAlleman Star 10457 Points 2713 Posts Re: Error 948 version error Jun 09, 2011 11:50 AM|TabAlleman|LINK Looks like you need to follow the instructions in this document: http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91- -Tab Alleman Reply kilofafeure Member 233 Points 769 Posts Re: Error 948 version error Jun 10, 2011 02:53 AM|kilofafeure|LINK Thanks but the adrress is not complete and I can't see anything...XDDD Ever than a programmer makes an extra hour god kills a kitten Reply Damon Liu -... Contributor 5804 Points 503 Posts Re: Error 948 version error Jun 12, 2011 10:51 PM|Damon Liu - MSFT|LINK Hi kilofafeure, Thank you for the post. I understand that Error 948 was received when try to attach a database, and some articles have been viewed. From the description, I noticed that a SQL Server 2008 R2 version .mdf was trying to attach to the SQL Server 2008 instance. Thus our issue can be