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.
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 |
|
|
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 andc:\my ducuments\my project\database.ldf. |
|
|
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.- LumbagoMy blog-> http://thefirstsql.com |
|
|
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. |
|
|
|
|
|