Re: A Question on Database Restore
From: Peter Yeoh (nospam_at_nospam.com)
Date: 06/27/04
- Next message: Uri Dimant: "Re: Aggregate functions"
- Previous message: Kit: "A Question on Database Restore"
- In reply to: Kit: "A Question on Database Restore"
- Next in thread: Dan Guzman: "Re: A Question on Database Restore"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 27 Jun 2004 15:12:45 +0800
Try 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
>
>
- Next message: Uri Dimant: "Re: Aggregate functions"
- Previous message: Kit: "A Question on Database Restore"
- In reply to: Kit: "A Question on Database Restore"
- Next in thread: Dan Guzman: "Re: A Question on Database Restore"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
