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)
 Restore Database problem
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Bill_C
Constraint Violating Yak Guru

United Kingdom
296 Posts

Posted - 10/10/2013 :  05:42:32  Show Profile  Reply with Quote
SQL Server 2008R2
Clustered - 2 instances
Trying to restore database from instance1 to instance2 under a different name.

I am trying to restore a database from one cluster instance to a different cluster instance (same server but different drives) but also re-naming it in the process.

I have tried copying the latest backup file from the backup drive of instance1 to the backup drive of instance2, and then using the 'Restore database' wizard to point at the location I copied the original backup too.

I change the file 'Restore as' locations to point at where the mdf & ldf files should be for that instance but the restore fails with the error 'Directory Lookup for the file....... Failed'

Any ideas on getting around this?

tkizer
Almighty SQL Goddess

USA
37135 Posts

Posted - 10/10/2013 :  11:41:32  Show Profile  Visit tkizer's Homepage  Reply with Quote
If it's a clustered instance, then the drives must be drives that are configured for that instance. Can you show us the command the wizard is trying to run? The wizard has a scripting option at the top.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Bill_C
Constraint Violating Yak Guru

United Kingdom
296 Posts

Posted - 10/14/2013 :  03:41:07  Show Profile  Reply with Quote
quote:
Originally posted by tkizer

If it's a clustered instance, then the drives must be drives that are configured for that instance. Can you show us the command the wizard is trying to run? The wizard has a scripting option at the top.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/



Thanks for the input TK, I have changed the paths according to where they should be for the new instance (they were pointing to drives F:\ & G:\, now pointing to J:\ & K:\)

The backup file (as stated in post 1) has been copied to where the main backups for the second instance live.


RESTORE DATABASE [RestDB] 
FROM  DISK = N'L:\MSSQL10.SECURE\MSSQL\Backup\OrigDB_20131009193032.BAK' 
WITH  FILE = 1,  MOVE N'OrigDB' TO N'J:\MSSQL10.MSSQLSERVER\MSSQL\DATA\RestDB.mdf',  
MOVE N'OrigDB_P2' TO N'J:\MSSQL10.MSSQLSERVER\MSSQL\DATA\RestDB_1.ndf',  
MOVE N'OrigDB_Ind' TO N'J:\MSSQL10.MSSQLSERVER\MSSQL\DATA\RestDB_2.ndf',  
MOVE N'OrigDB_Sec' TO N'J:\MSSQL10.MSSQLSERVER\MSSQL\DATA\RestDB_3.ndf',  
MOVE N'OrigDB_log' TO N'K:\MSSQL10.MSSQLSERVER\MSSQL\log\RestDB_4.ldf',  
NOUNLOAD,  STATS = 10
GO


This has sort of slipped down the priority list for now, (due to other more preesing matters) although I would like to get a successfull transfer as I have not done this before.

I will re-visit this thread when things calm down a little here at work. Hopefully then we can ressurect it and set me on the path to a successfull transfer.


Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37135 Posts

Posted - 10/14/2013 :  11:39:50  Show Profile  Visit tkizer's Homepage  Reply with Quote
It looks good. If you are still getting that error, then I suspect something is amiss in the cluster config in that it can't see the J or K drives. Try creating a blank database using these exact same files and locations.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
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.05 seconds. Powered By: Snitz Forums 2000