August 12, 2014 at 9:41 am
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
August 12, 2014 at 9:42 am
What are the error messages? I don't have all of the error codes memorised.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2014 at 4:54 am
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)
August 13, 2014 at 5:25 am
The unit of work was initiated before DDF was started, and the application attempted to perform a distributed operation. The unit of work must be terminated by a rollback operation.
An application that performs local database updates before DDF is started cannot perform distributed operations within the same unit of work. The current unit of work must be terminated by a rollback operation and a new unit of work must be initiated before any SQL operations can be performed.
August 13, 2014 at 5:42 am
enriquemallon (8/13/2014)
The unit of work was initiated before DDF was started, and the application attempted to perform a distributed operation. The unit of work must be terminated by a rollback operation.An application that performs local database updates before DDF is started cannot perform distributed operations within the same unit of work. The current unit of work must be terminated by a rollback operation and a new unit of work must be initiated before any SQL operations can be performed.
??? Posted in the wrong thread by accident?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2014 at 5:44 am
arzmohd2k8 (8/13/2014)
Database connectivity cannot be opened because it is version 661. This server support version 655 and earlierA downgrade path is not supported.
You're trying to attach a SQL Server 2008 R2 database to SQL Server 2008. They are different versions (like SQL 2012 and SQL 2014). You cannot downgrade databases.
You'll have to find a SQL Server 2008 R2 instance to attach this DB to.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2014 at 3:06 am
GilaMonster (8/12/2014)
What are the error messages? I don't have all of the error codes memorised.
An expert would. 😉
qh
August 14, 2014 at 3:37 am
quackhandle1975 (8/14/2014)
GilaMonster (8/12/2014)
What are the error messages? I don't have all of the error codes memorised.An expert would. 😉
Good thing I don't claim to be an expert then, isn't it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2014 at 3:57 am
GilaMonster (8/14/2014)
quackhandle1975 (8/14/2014)
GilaMonster (8/12/2014)
What are the error messages? I don't have all of the error codes memorised.An expert would. 😉
Good thing I don't claim to be an expert then, isn't it.
I think many on here (myself included, as I saw your presentation at Bits) see you as one. :satisfied:
qh
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply