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.
SQL Server MVP since 2007
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
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.