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
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.
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.