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 |
|
sagitariusmzi
Posting Yak Master
113 Posts |
 Posted - 2010-02-09 : 01:21:46
|
| Hi, Is it possible to Attach the MDF and LDF files of SQL Server 2008 to SQL Server 2005 ?Regards |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-02-09 : 02:28:04
|
| No.A database attached to a SQL 2008 server is a SQL 2008 database and cannot be restored/attached to a lower version.--Gail ShawSQL Server MVP |
 |
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2010-02-09 : 02:34:41
|
| If i have a Database in Sql Server 2008 Is there that i can take that Database in Lower versions like Sql Server 2005 ? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-02-09 : 05:04:26
|
| No.A database attached to a SQL 2008 server is a SQL 2008 database and cannot be restored/attached to a lower version.You cannot move a database from a higher version (SQL 2008) to a lower version (SQL 2005). You will need to script out all objects, export all data and recreate the DB on the lower version.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Attach MDF/LDF files of Sql2008 to SQL2005