Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 How to restore 2005 ndf to SQL 2008?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

24 Posts

Posted - 03/04/2009 :  01:34:07  Show Profile  Reply with Quote
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\MUNDOQA

This is what i get in SQL2008 when i try to restore

This is the path in SQL2005

This is the error.

Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 03/04/2009 :  05:40:06  Show Profile  Reply with Quote
Do this in a script instead as it seems you are trying to move the filegroups as well as restoring.

Look up in BoL:

Go to Top of Page

Starting Member

24 Posts

Posted - 03/04/2009 :  06:06:35  Show Profile  Reply with Quote
it used to be so easy on SQL2005? why they want to make life suffer?
Go to Top of Page

Starting Member

24 Posts

Posted - 03/04/2009 :  23:13:22  Show Profile  Reply with Quote
is it really no other way of doing this ?? such as few clicks in SQL2005?
Go to Top of Page

Posting Yak Master

115 Posts

Posted - 03/05/2009 :  12:39:34  Show Profile  Visit heavymind's Homepage  Send heavymind an ICQ Message  Reply with Quote
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, Vadym
MCITP DBA 2005/2008
Chief DBA at
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000