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 |
|
neo_6053
Starting Member
24 Posts |
 Posted - 2009-03-04 : 01:34:07
|
i have a database with multiple ndf file in SQL2005. I want to restore it into sql2008 in my server. Thus, i create a new database in SQL2008 and restore the backup file from SQL2005. I have created the database in a folder. This is the path of the new database i create in SQL2008 : Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\MUNDOQAThis is what i get in SQL2008 when i try to restore This is the path in SQL2005 This is the error. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-03-04 : 05:40:06
|
| Do this in a script instead as it seems you are trying to move the filegroups as well as restoring.Look up in BoL:RESTORE DATABASE WITH MOVE |
 |
|
|
neo_6053
Starting Member
24 Posts |
Posted - 2009-03-04 : 06:06:35
|
| =_= it used to be so easy on SQL2005? why they want to make life suffer? |
|
|
|
neo_6053
Starting Member
24 Posts |
Posted - 2009-03-04 : 23:13:22
|
| is it really no other way of doing this ?? such as few clicks in SQL2005? |
|
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-03-05 : 12:39:34
|
| you are probably trying to attach some files from inexisting locations.checkout all files really exists and exactly by the pathes showed by your screenshots. there should be no problem attaching 2005 files to 2008.Thanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
|
|
|
|
|
|
How to restore 2005 ndf to SQL 2008?