Restore Database With MOVE
Posted on 2010-11-15
I'm stumped with this one and I am hoping you could help me.
I am trying to restore a database into another server. I ran a RESTORE FILELISTONLY and this is what I got.
RESTORE FILELISTONLY FROM DISK = '\\SomeSharedDrive\Backup$\SomeFolder\DummyDB_LIVE.bak'
DB_data D:\SQLServer\MSSQL\Data\DummyDB_LIVE_data.MDF D PRIMARY 292749312 35184372080640
DB_log E:\SQLServer\MSSQL\Data\DummyDB_LIVE_Log.LDF L NULL 104595456 35184372080640
I ran the following command:
Restore database DummyDB_LIVE
from disk = '\\SomeSharedDrive\Backup$\SomeFolder\DummyDB_LIVE.bak'
with move 'DB_data' to 'F:\SQLServer\MSSQL\data\DummyDB_LIVE_data.mdf',
move 'DB_log' to 'G:\SQLServer\MSSQL\data\DummyDB_LIVE_Log.ldf',
I got this error:
Msg 3156, Level 16, State 1, Line 3
File 'DB_log' cannot be restored to 'G:\SQLServer\MSSQL\data\DummyDB_LIVE_Log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3013, Level 16, State 1, Line 3
RESTORE DATABASE is terminating abnormally.
I can confirm that the paths are correct. The user account used by SQL Server service is permissioned with read/write access to its respective folders.
SQL server version is SQL Server 2000.
What else am I missing?