Mssql Error 948
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you sql server error 948 version 661 might have Meta Discuss the workings and policies of this site error 948 in sql server 2008 r2 About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or sql server error 948 version 706 posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of
Sql Server Version 706
6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL Server 2008, Error: 948 While Attach Database got Version error? up vote -1 down vote favorite 1 Yesterday I installed SQL Server 2008 on my laptop (Windows 7 64 bit), I need to attach a the database cannot be opened because it is version 661 this server supports version 655 and earlier .mdf to the server, but when I try to do this, I get this error: Attach Database failed for server 'prince/sqlexpress' (Microsoft.SqlServer.smo) ADDITIONAL INFORMATION: 1.An Exception Occured while executing a Transact Sql statement or Batch (Microsoft.SqlServer.connectioninfo) 2.Unable to open the Physical file Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120) With the help of Internet, I found some solution. 1.Start SQL Server manager as Administrator (right-click on the program, choose "Start as administrator"): But I still got the same error. That .mdf file does have have permission, so I moved into external drive (pendrive because my system have only C:\ drive, yet no partition I have done ) . Then I got another error, Attach database failed for Server 'Prince\SQLEXPRESS'. (Microsoft.SqlServer.Smo) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The database 'Databasename' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path
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 create database is aborted. (microsoft sql server, error: 948) Learn more about Stack Overflow the company Business Learn more about hiring developers
The Database Cannot Be Opened Because It Is Version 661 This Server Supports Version 612 And Earlier
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
Upgrade Sql Server 2008 To R2
Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL Server Management Studio error 948 up http://stackoverflow.com/questions/11167113/sql-server-2008-error-948-while-attach-database-got-version-error vote 0 down vote favorite 1 I tried to attach a database (.mdf) file and I got this error: Attach database failed for Server '...\SQLINSTANCE'. (Microsoft.SqlServer.Smo) Additional information: An exception occured while executing a Transact-SQL statement or batch. (Microfost.SqlServer.ConnectionInfo) The database 'DBName' cannot be opened because it is version 782. This server supports version 706 or earlier. A downgrade path is not supported. Could not open new http://stackoverflow.com/questions/22983461/sql-server-management-studio-error-948 database 'DBName'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948) P.S. I have installed SQL Server 2012 Express, and database 'DBName' has been made in Visual Studio 2012. sql-server sql-server-2008 share|improve this question edited Apr 10 '14 at 9:09 jackJoe 7,89973054 asked Apr 10 '14 at 9:05 Faruk 63110 Are you trying to put a 2008 mdf to a 2012 server? –apomene Apr 10 '14 at 9:08 782 is 2014, isn't it? –dean Apr 10 '14 at 9:15 You are trying to attach a db from a newer version of SQL to an older version –RezaRahmati Apr 10 '14 at 9:17 take a look at this connect.microsoft.com/VisualStudio/feedback/details/817399/… –RezaRahmati Apr 10 '14 at 9:21 @dean I just figured that out –Faruk Apr 10 '14 at 9:27 | show 1 more comment 1 Answer 1 active oldest votes up vote 1 down vote If you have source control Rollback the mdf file Rollback the idf file (log file) to the same version I had a similar problem and this solution fixed is. If you do not have source control and you are using Code First Backup the mdf a
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search http://www.sqlservercentral.com/Forums/Topic1602351-1549-1.aspx Members Calendar Who's On Home » SQL Server 2008 » SQL https://technet.microsoft.com/en-us/library/bb326472(v=sql.110).aspx Server 2008 High Availability » Please help me to solve MS SQL Error 948... Please help me to solve MS SQL Error 948 while I am attaching the database Rate Topic Display Mode Topic Options Author Message arzmohd2k8arzmohd2k8 Posted Tuesday, August 12, 2014 9:41 AM sql server Forum Newbie Group: General Forum Members Last Login: Wednesday, August 13, 2014 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 sql server error to solve this critical problem Post #1602351 GilaMonsterGilaMonster Posted Tuesday, August 12, 2014 9:42 AM SSC-Forever Group: General Forum Members Last Login: Today @ 3:31 PM Points: 45,423, Visits: 43,756 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 enriquemallonenrique
Microsoft Tech Companion App Microsoft Technical Communities Microsoft Virtual Academy Script Center Server and Tools Blogs TechNet Blogs TechNet Flash Newsletter TechNet Gallery TechNet Library TechNet Magazine TechNet Subscriptions TechNet Video TechNet Wiki Windows Sysinternals Virtual Labs Solutions Networking Cloud and Datacenter Security Virtualization Downloads Updates Service Packs Security Bulletins Windows Update Trials Windows Server 2016 System Center 2016 Windows 10 Enterprise SQL Server 2016 See all trials » Related Sites Microsoft Download Center TechNet Evaluation Center Drivers Windows Sysinternals TechNet Gallery Training Training Expert-led, virtual classes Training Catalog Class Locator Microsoft Virtual Academy Free Windows Server 2012 courses Free Windows 8 courses SQL Server training Microsoft Official Courses On-Demand Certifications Certification overview MCSA: Windows 10 Windows Server Certification (MCSE) Private Cloud Certification (MCSE) SQL Server Certification (MCSE) Other resources TechNet Events Second shot for certification Born To Learn blog Find technical communities in your area Support Support options For business For developers For IT professionals For technical support Support offerings More support Microsoft Premier Online TechNet Forums MSDN Forums Security Bulletins & Advisories Not an IT pro? Microsoft Customer Support Microsoft Community Forums United States (English) Sign in Home Library Wiki Learn Gallery Downloads Support Forums Blogs We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Errors and Events Reference Database Engine Events and Errors Cause and Resolution of Database Engine Errors Cause and Resolution of Database Engine Errors MSSQLSERVER_948 MSSQLSERVER_948 MSSQLSERVER_948 MSSQLSERVER_-2 MSSQLSERVER_-1 MSSQLSERVER_2 MSSQLSERVER_53 MSSQLSERVER_102 MSSQLSERVER_107 MSSQLSERVER_125 MSSQLSERVER_137 MSSQLSERVER_207 MSSQLSERVER_208 MSSQLSERVER_233 MSSQLSERVER_360 MSSQLSERVER_511 MSSQLSERVER_601 MSSQLSERVER_605 MSSQLSERVER_611 MSSQLSERVER_617 MSSQLSERVER_701 MSSQLSERVER_802 MSSQLSERVER_823 MSSQLSERVER_824 MSSQLSERVER_825 MSSQL