asked on

Cannot ATTACH files after upgrading to Sql Server 2008 from 2005

After upgrading to SQL-Server from 2005 to '2008 with tools'. I can open and reattach most data files through Sql Server Management Studio. However, one database throws an error and refuses to attach.

How may I resolve this issue?

USE [master]
GO
CREATE DATABASE [Workload] ON 
 ( FILENAME = N'C:\Documents and Settings\All Users\Documents\Work\Workload_Data.MDF' ),
 ( FILENAME = N'C:\Documents and Settings\All Users\Documents\Work\Workload_Log.LDF' )
FOR ATTACH
GO
 
----
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'Workload'. CREATE DATABASE is aborted.
Msg 948, Level 20, State 1, Line 1
The database 'Workload' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.

Open in new window

ASKER CERTIFIED SOLUTION

Mark Wills

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

graye

Where did that Workload database come from? It appears to have a 'foreign' version number...

Mark Wills

Have seen a problem when there are multuiple servers involved (but that was on Vista version) when the database was created under VS or VWD and then SQL Server installed over the top - the database just would not attach untill the different named instances were tidied up and had just the one server. That is also why it though it had a more recent version number - it wasn't more recent, just different, and still OK for SQL 2008 (after the different instance were cleansed).

Still, think the SQL backup / restore would be best... (and talking aout the SQL Backup facility, not from a disk backup tool).

GreymanMSC

ASKER

Good morning.

Well, I'll give it a try, guys. We'll see how it goes later today.

Thanks.