Restore Database problem - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Restore Database problem

Author

Topic

Bill_C
Constraint Violating Yak Guru

299 Posts

Posted - 2013-10-10 : 05:42:32

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

38200 Posts

Posted - 2013-10-10 : 11:41:32

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/

Bill_C
Constraint Violating Yak Guru

299 Posts

Posted - 2013-10-14 : 03:41:07

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.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-10-14 : 11:39:50

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources