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 |
|
anjali66
Starting Member
23 Posts |
 Posted - 2011-01-10 : 18:56:31
|
| Is their any way I can attach the 2008 Sql server .mdf file to sql server 2005. If it is not possible at all, can I just make the backup in 2008 R2 and restore the backup in sql server 2005. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-10 : 19:23:52
|
| No and no.To "downgrade" you'll need to script out the objects, create them on the target server then insert the records (via BCP, SSIS, or if the servers are linked...T-SQL statements). |
 |
|
|
|
|
|
Attaching the database in older version