SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

neo_6053
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.





RickD
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:

RESTORE DATABASE WITH MOVE
Go to Top of Page

neo_6053
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

neo_6053
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

heavymind
Posting Yak Master

Ukraine
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 http://www.db-staff.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.06 seconds. Powered By: Snitz Forums 2000