A Question on Database Restore

Dear All
I have a question on database restore in SQL server 2000.
I would like to restore a BAK file which is stored in another server. But
when i try to restore the BAK file through the restore wizard, i cannot find
the network drive and it can only show the local drive of the server.
Would you please kindly help to solve my problem, thanks a lot.
KitTry entering the UNC name of the shared drive and backup file directly in
the file name input box, assuming you have granted the appropriate
permissions. Alternatively, you could use the TSQL syntax directly e.g.
RESTORE DATABASE xx FROM DISK = '\\serverx\sharename'
(for a full database restore).
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kit" <yuck@.ha.org.hk> wrote in message
news:%23ukLxGBXEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Dear All
> I have a question on database restore in SQL server 2000.
> I would like to restore a BAK file which is stored in another server. But
> when i try to restore the BAK file through the restore wizard, i cannot
find
> the network drive and it can only show the local drive of the server.
> Would you please kindly help to solve my problem, thanks a lot.
> Kit
>|||To add to Peter's response, it is the SQL Server service account that needs
permissions to the share.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Kit" <yuck@.ha.org.hk> wrote in message
news:%23ukLxGBXEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Dear All
> I have a question on database restore in SQL server 2000.
> I would like to restore a BAK file which is stored in another server. But
> when i try to restore the BAK file through the restore wizard, i cannot
find
> the network drive and it can only show the local drive of the server.
> Would you please kindly help to solve my problem, thanks a lot.
> Kit
>