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

SQL Server 2008 - DB failed to attach Expand / Collapse
Author
Message
Posted Saturday, October 20, 2012 9:59 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 18, 2014 10:45 PM
Points: 119, Visits: 490
SQL Server 2008 - DB failed to attach
DB files are of SQL Server 2008. I reinstalled, but still I see the same error.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'WINDOWS7ULTIMAT\MONSTER'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1442.32+((SQL_PreRelease).080529-2343+)&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 'MyTransactionDB' cannot be opened because it is version 655. This server supports version 654 and earlier. A downgrade path is not supported.
Could not open new database 'MyTransactionDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


Cheers,
- Win
"Dont Judge a Book by its Cover"
Post #1375110
Posted Saturday, October 20, 2012 10:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:38 AM
Points: 223, Visits: 1,725
"The database version number for 2008 RTM and SP1 is 655." so you have to install proper version of SQL 2008, RTM or SP1
http://sqlskills.com/BLOGS/PAUL/post/SQL-Server-2008-R2-bumps-the-database-version.aspx
Post #1375111
Posted Saturday, October 20, 2012 11:32 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 6:16 AM
Points: 39,896, Visits: 36,242
Please run SELECT @@version


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 #1375116
Posted Saturday, October 20, 2012 10:26 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 18, 2014 10:45 PM
Points: 119, Visits: 490
Microsoft SQL Server 2008 (CTP) - 10.0.1442.32 (Intel X86) May 30 2008 00:02:15 Copyright (c) 1988-2007 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 6.1 <X86> (Build 7600: )

Cheers,
- Win
"Dont Judge a Book by its Cover"
Post #1375140
Posted Sunday, October 21, 2012 4:03 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 6:16 AM
Points: 39,896, Visits: 36,242
Uninstall that and install the release version of SQL 2008. I don't know how you have a CTP still working, unless you're playing tricks with the system clock. All CTPs should have stopped working years ago.


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 #1375153
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse