I want to restore backup from mapped network drive which i have shared in MSSQL server 2003.
I have mapped a network drive & given sharing to the folder.
I am using a batch file to restore it...contains of the file is as below :
SQLCMD -i RESTORMIS.txt -o RESTOR_outpu.log
and RESTORMIS.txt contains as below :
RESTORE DATABASE PRODRDCC
FROM DISK = '\\192.168.0.91\D$\DATA\CBS\FULL.BAK'
WITH
MOVE 'SDCPROD' to 'D:\DATA\RDCC_MIS\PRODRDCC.mdf',
MOVE 'SDCPROD_log' to 'D:\DATA\RDCC_MIS\PRODRDCC_log.ldf',
MOVE 'MDATA01' to 'D:\DATA\RDCC_MIS\Mdata.ndf',
MOVE 'MINDEX01' to 'D:\DATA\RDCC_MIS\Mindex.ndf',
MOVE 'TDATA01' to 'D:\DATA\RDCC_MIS\Tdata.ndf',
MOVE 'TINDEX01' to 'D:\DATA\RDCC_MIS\Tindex.ndf',
REPLACE
GO
After executing this batch file I am getting error log file contains as below :
"Msg 3201, Level 16, State 2, Server PRAKASH, Line 1
Cannot open backup device '\\192.168.0.91\D$\DATA\CBS\FULL.BAK'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Server PRAKASH, Line 1
RESTORE DATABASE is terminating abnormally."
But if I put the address \\192.168.0.91\D$\CBS\ in RUN command I am getting the file ..
Pl provide me the solution for above...