restore database

Using SS2000. I'm trying to restore a database to a server other than the
server that it was originally on. I don't have enough room to restore it to
the original server. The backup file is on the network.
I've tried variations of this
RESTORE DATABASE tmxvesta_dev
FROM
\\Memphis\AM\Depts\Technology\SQLServer\Backups\Maximus\bk_dv_tmxvestaDev.bak
WITH NORECOVERY
and this
RESTORE DATABASE tmxvesta_dev
FROM bk_dv_tmxvestaDev
WITH
FILE = H:\Depts\Technology\SQLServer\Backups\Maximus\bk_dv_tmxvestaDev.bak
NORECOVERY
and I get errors like this
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'H:'.
Can I create a new device on the second server and point it to the .bak file
on the network server? I can't move the file to the second server because it
is too big.
Thanks,
--
Dan D.I got it. This is what I used:
RESTORE DATABASE tmxvesta_dev
FROM disk ='\\Memphis\AM\Depts\Technology\SQLServer\Backups\Maximus\bk_dv_tmxvestaDev.bak'
WITH NORECOVERY
"Dan D." wrote:
> Using SS2000. I'm trying to restore a database to a server other than the
> server that it was originally on. I don't have enough room to restore it to
> the original server. The backup file is on the network.
> I've tried variations of this
> RESTORE DATABASE tmxvesta_dev
> FROM
> \\Memphis\AM\Depts\Technology\SQLServer\Backups\Maximus\bk_dv_tmxvestaDev.bak
> WITH NORECOVERY
> and this
> RESTORE DATABASE tmxvesta_dev
> FROM bk_dv_tmxvestaDev
> WITH
> FILE = H:\Depts\Technology\SQLServer\Backups\Maximus\bk_dv_tmxvestaDev.bak
> NORECOVERY
> and I get errors like this
> Server: Msg 170, Level 15, State 1, Line 4
> Line 4: Incorrect syntax near 'H:'.
> Can I create a new device on the second server and point it to the .bak file
> on the network server? I can't move the file to the second server because it
> is too big.
> Thanks,
> --
> Dan D.