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
Try 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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment