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 |
|
azeeee
Starting Member
3 Posts |
 Posted - 2012-01-03 : 11:02:32
|
| Hi Guys,Can I attach an MDF file from a SQL Server 2005 database to a SQL Server 2008 R2 database?I am trying to do that but the MDF file is not visible when I browse to attach it.Thanks, Ahmed |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-03 : 11:11:26
|
| Yes you can.Is the mdf file on the server or your machine ?After Monday and Tuesday even the calendar says W T F .... |
 |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-01-03 : 11:48:53
|
| Make sure you have a backup of the mdf before you attach it.----------------------------Junior DBA learning the ropes |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-03 : 12:12:31
|
| You need the ldf as well, otherwise it may fail to attach. Make sure SQL has full permissions to the folder with the database files.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Attaching a SQL 2005 MDF file to SQL 2008 DB