restoring from network drive

Ok -I'm drawing a huge blank.
After a new install of SQL2K and SP3a, I'm unable to restore a backup from a
network drive.
SQL services are logging on with a domain account
The SQL service account has also been granted Local admin access on the PC
When trying to restore a database from Device, the only drive listed is the
local C: drive - none of the mapped drives are available.
JTTry entering a UNC name for the name of the backup, something like:
\\backupserver\sharename\backup\database.bak
Also note the MSSQLSERVER service account will need access to the network
share.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"JT" <JT_*n*o*s*p*a*m*Goalie33@.cox.net> wrote in message
news:WAZzc.4489$cj3.1501@.lakeread01...
> Ok -I'm drawing a huge blank.
> After a new install of SQL2K and SP3a, I'm unable to restore a backup from
a
> network drive.
> SQL services are logging on with a domain account
> The SQL service account has also been granted Local admin access on the PC
> When trying to restore a database from Device, the only drive listed is
the
> local C: drive - none of the mapped drives are available.
> JT
>|||SQL Server will only show local drives/partitions on the
computer you are trying to restore to...Use UNC names/IP
adresses when restoring from a network drive.
EX:
RESTORE DATABASE MYDATABASE
FROM DISK = '\\SERVER1\D$\Program Files\Microsoft SQL
Server\MSSQL\Backup\MYDATABASE\MYDATABASE.BAK'
WITH
DBO_ONLY,
REPLACE,
STANDBY = '\\SERVER1\D$\Program Files\Microsoft SQL
Server\MSSQL\Backup\MYDATABASE\'UNDO_MYDATABASE.ldf',
MOVE 'MYDATABASE_Data' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MYDATABASE_Data.mdf',
MOVE 'MYDATABASE_Log' TO 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MYDATABASE_Log.ldf'
e.t.c
>--Original Message--
>Ok -I'm drawing a huge blank.
>After a new install of SQL2K and SP3a, I'm unable to
restore a backup from a
>network drive.
>SQL services are logging on with a domain account
>The SQL service account has also been granted Local admin
access on the PC
>When trying to restore a database from Device, the only
drive listed is the
>local C: drive - none of the mapped drives are available.
>JT
>
>.
>