Skip to main content
1 of 2
sairam
  • 291
  • 3
  • 5
  • 12

How to restore Network backup to Network Path in sqlserver 2005?

I am trying to restore network backup file to network path.. is there any way to do it.. i am using SQl server 2005 and code....

RESTORE DATABASE DB_NAme
FROM DISK = N'\\NetworkPath\backup_20140501030004.BAK'
WITH  FILE = 1
, MOVE 'DB_Data' TO '\\NetworkPath\DATA\DB.mdf'
, MOVE 'DB_Data2' TO '\\NetworkPath\DATA\DB_1.mdf'
, MOVE 'DB_Data3' TO '\\NetworkPath\DATA\DB_2.mdf'
, MOVE 'DB_Log' TO '\\NetworkPath\Log\DB_log.ldf'
, NOUNLOAD,REPLACE, STATS = 10;

Error :-

Msg 5110, Level 16, State 2, Line 2
The file "\\NetworkPath\DATA\DB.mdf" is on a network path that is not supported for database files.
Msg 3156, Level 16, State 3, Line 2
File 'DB_Data' cannot be restored to '\\NetworkPath\DATA\DB.mdf'. Use WITH MOVE to identify a valid location for the file.

Thanks in Advance

sairam
  • 291
  • 3
  • 5
  • 12