I have a backup file in a portable hard drive directly attached to the server ( one that has Sql sever )
I am going to do a restore using the following command:
restore database NGDEVL
from disk = N'R:\NGDVLBK12032010' -- assumes the file is local - Ask Dave for the path of the file.
with file = 1,
move 'NextGen_System_Data' to 'M:\SQL Data Files DBI02\MSSQL.4\MSSQL\Data\NGDevl_System_Data.mdf',
move 'NextGen_Core_Data_1' to 'X:\Data\NGDevl_Core_Data_1.ndf',
move 'NextGen_Index_1' to 'M:\SQL Data Files DBI02\MSSQL.4\MSSQL\Data\NGDevl_Index_1.ndf',
move 'NextGen_Log' to 'N:\SQL Log Files DBI02\NGDevl_Log.ldf',
stats = 10;
Points to note:
R: points to the drive letter assigned to the portable hard drive.
M: refers to the drive that has Sql server.
x: refers to a mapped drive in another server.
Here is my question:
Will the RESTORE work with mapped drives ( where the actual drive sits in another server )