Ms Sql Server Error 948
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL sql server error 948 version 661 Server 2008 » SQL Server 2008 High Availability » Please help me
Error 948 In Sql Server 2008 R2
to solve MS SQL Error 948... Please help me to solve MS SQL Error 948 while I am attaching sql server error 948 version 706 the database Rate Topic Display Mode Topic Options Author Message arzmohd2k8arzmohd2k8 Posted Tuesday, August 12, 2014 9:41 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, August 13, 2014
Create Database Is Aborted. (microsoft Sql Server, Error: 948)
1:02 PM Points: 2, Visits: 3 Hello dear!I am facing a problem with MS SQL Server 2008 R2 while attaching a database file, the error code is 948, I tried to solve it but still me getting same error so please help me to solve this critical problem Post #1602351 GilaMonsterGilaMonster Posted Tuesday, August 12, 2014 9:42 AM SSC-Forever Group: General Forum the database cannot be opened because it is version 661 this server supports version 655 and earlier Members Last Login: Today @ 2:03 PM Points: 45,423, Visits: 43,755 What are the error messages? I don't have all of the error codes memorised. Gail ShawMicrosoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enterWe stand on the bridge and no one may pass Post #1602352 arzmohd2k8arzmohd2k8 Posted Wednesday, August 13, 2014 4:54 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, August 13, 2014 1:02 PM Points: 2, Visits: 3 This error occurred while attaching database file:An exception was occurred while executing a-trasact SQL Statment or Batch(Microsoft.SqlServer.ConnectionInfo)Database connectivity cannot be opened because it is version 661. This server support version 655 and earlier A downgrade path is not supported.Could not open new database 'connectivity'. CREATE DATABASE aborted. (Microsoft SqlServer, Error:948) Post #1602648 enriquemallonenriquemallon Posted Wednesday, August 13, 2014 5:25 AM SSC Rookie Group: General Forum Members Last Login: Wednesday, October 29, 2014 1:09 AM Points: 33, Visits: 54 The unit of work was initiated before DDF was started, and the app
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
Microsoft Sql Server 2005 Error 948
errors I have been getting when attaching a database has been
Sql Version 782
far too many. But the best part of this learning experience is that I get to write the database cannot be opened because it is version 661 this server supports version 612 and earlier about them one after another. There are no right or wrong answers sometimes, but am learning every time. Here is an error which is related to a downgrade http://www.sqlservercentral.com/Forums/Topic1602351-1549-1.aspx 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 [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, http://blog.sqlauthority.com/2016/06/25/sql-server-fix-error-948-downgrade-path-not-supported/ 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. 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
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered https://social.msdn.microsoft.com/Forums/sqlserver/en-US/60df9c2b-b815-4872-9cc2-945f8f23d86c/sql-server-management-studio-2012-error?forum=sqlexpress by: Sql server management studio 2012 error SQL Server > http://dba.stackexchange.com/questions/31408/how-to-downgrade-my-mdf-file-from-version-661-to-655-or-earlier SQL Server Express Question 0 Sign in to vote Hi, i used sql server management studio 2012 to create a database but when itry to attachthe database on other pc with the same version of sql i have this error: sql server TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server '*******-PC\SQLEXPRESS'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1846+)&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 '*****' cannot be opened because it is version 706. This server supports version 655 and sql server error earlier. A downgrade path is not supported. Could not open new database 'GesMan'. 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 ------------------------------ Thursday, April 26, 2012 8:30 PM Reply | Quote Answers 0 Sign in to vote oh you're right...so how can i solve this? you can attach the database only to a SQL Sever 2012 (or higher - in the future) and therefore you need to install SQL Server 2012 on the other computer. As you already using SQL Server 2012 Express edition, install the same edition on the 2nd computer. Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful. Proposed as answer by Iric WenModerator Monday, April 30, 2012 2:24 AM Marked as answer by Iric WenModerator Friday, May 04, 2012 9:07 AM Thursday, April 26, 20
log in tour help Tour Start 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 developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top How to downgrade my mdf file from version 661 to 655 or earlier? up vote 1 down vote favorite I have a problem when attaching the file AdverntureWorksLT2008R2_Data.mdf to Microsoft SQL Server Management Studio (SSMS). The database 'AdventureWorksLT2008R2' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database 'AdventureWorksLT2008R2'. CREATE DATABASE is aborted. )Microsoft SQL Server, Error: 948) So, I was wondering if it is possible to do something on the .mdf file so that the .mdf file will be downgrade to version 655 or earlier. There is a similar question(s) such as this - Attaching database to the SQL server The correct answer mention about getting to know more about the version and one suggest that latest Service Pack must be installed. I have checked the version and notice that the latest Service Pack have been installed. So, I was thinking of downgrade the mdf file but how do I downgrade it? ssms share|improve this question edited Jan 4 '13 at 5:53 marc_s 5,41632843 asked Jan 4 '13 at 5:50 Jack 760102235 You could always download the correct version of the AdventureWorks sample database from Codeplex. –Mark Storey-Smith Jan 4 '13 at 15:19 1 Just a side note: you don't attach a .mdf file "to SSMS", you