Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SQL server 2005 data base not attaching to 2008

Author  Topic 

meet_binay
Starting Member

10 Posts

Posted - 2013-06-16 : 10:51:44
Hi,
I have databse .mdf and log file of sql 2005. But while attaching it to SQL 2008 the error shows
" this data base is of version 655. This server supports versions till 654."

This error should show for attaching 2008 data base to SQL 2005.
Not for higher version.
Please help

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-06-16 : 12:48:42
quote:
Originally posted by meet_binay

Hi,
I have databse .mdf and log file of sql 2005. But while attaching it to SQL 2008 the error shows
" this data base is of version 655. This server supports versions till 654."

This error should show for attaching 2008 data base to SQL 2005.
Not for higher version.
Please help

That indeed means that the database is not a SQL 2005 file database. I may be mistaken (you can google for this), but I think 611 or 612 is SQL 2008, 655 is SQL 2008 and 661 is SQL 2008 R2. So likely you are trying to attach a 2008 database to an instance of SQL 2005
Go to Top of Page

meet_binay
Starting Member

10 Posts

Posted - 2013-06-16 : 23:54:45
But i have sql server 2008 installed and the data base is of sql 2005 for sure.
I had two databases of sql 2005. one is attaching properly.
In attach wizard of sql 2008 ,the one which is giving problem while attaching shows a full physical path of database in database name and attach e.g. c:\my ducuments\my project\database.mdf and
c:\my ducuments\my project\database.ldf.
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2013-06-17 : 04:02:59
Take a backup of the 2005 database and restore it to 2008 instead.

- Lumbago
My blog-> http://thefirstsql.com
Go to Top of Page

meet_binay
Starting Member

10 Posts

Posted - 2013-06-17 : 04:25:21

In the attach wizard of sql 2008 when i am adding database mdf file in the "Database to attach" portion the

database name is shown as "C:\my documents\my project\database.mdf instead of just database.mdf.
Is that the cause of the problem? This is the pah where I kept the database file prior to formatting my pc.
Go to Top of Page
   

- Advertisement -