I have a script to restore a database the thing is that the bak file is on the network, when I go to browse to that file SQL server says it can't find the file. It seems that it is looking for a drive.
Restore database jeffdb from disk =
MOVE 'Jeffdb_dat' TO 'd:mssql\backup\jeffdb.mdf',
MOVE 'Jeffdb_log' TO 'd:mssql\backup\jeffdb.ldf'
Do I have to put the server name and use the $ sign to specify a drive??