SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SQL server 2005 data base not attaching to 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

meet_binay
Starting Member

India
10 Posts

Posted - 06/16/2013 :  10:51:44  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3585 Posts

Posted - 06/16/2013 :  12:48:42  Show Profile  Reply with Quote
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

India
10 Posts

Posted - 06/16/2013 :  23:54:45  Show Profile  Reply with Quote
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

Norway
3271 Posts

Posted - 06/17/2013 :  04:02:59  Show Profile  Reply with Quote
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

India
10 Posts

Posted - 06/17/2013 :  04:25:21  Show Profile  Reply with Quote

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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000