Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Please help me to solve MS SQL Error 948 while I am attaching the database Expand / Collapse
Author
Message
Posted Tuesday, August 12, 2014 9:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 to solve this critical problem
Post #1602351
Posted Tuesday, August 12, 2014 9:42 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
What are the error messages? I don't have all of the error codes memorised.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1602352
Posted Wednesday, August 13, 2014 4:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, August 13, 2014 5:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 4:20 AM
Points: 24, Visits: 30
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.
Post #1602665
Posted Wednesday, August 13, 2014 5:42 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1602676
Posted Wednesday, August 13, 2014 5:44 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
arzmohd2k8 (8/13/2014)

Database connectivity cannot be opened because it is version 661. This server support version 655 and earlier

A 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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1602677
Posted Thursday, August 14, 2014 3:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:49 AM
Points: 2,404, Visits: 992
GilaMonster (8/12/2014)
What are the error messages? I don't have all of the error codes memorised.


An expert would.

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1603169
Posted Thursday, August 14, 2014 3:37 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 39,866, Visits: 36,207
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1603181
Posted Thursday, August 14, 2014 3:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:49 AM
Points: 2,404, Visits: 992
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.

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1603192
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse