Hi,
It seems that SQL Server does not permit a restore from a non-local drive
(dataset). Does anyone have a technique to accomplish a restore from a
non-local drive?
Thank you,
Nick

On Jun 12, 9:44am, "Nick Giordano" <n...@njginc.com> wrote:
> Hi,
> It seems that SQL Server does not permit a restore from a non-local drive
> (dataset). Does anyone have a technique to accomplish a restore from a
> non-local drive?
> Thank you,
> Nick

At a bare minimum:
RESTORE DATABASE MyDB FROM DISK = '\\Server\Sharename'

You may need to include various options to overwrite an existing
database, place files in alternate locations, etc... You'll also need
to ensure that the SQL Server service account as read-access to \
\Server\Sharename.

Also point to note, if you are using UNC path to access the backups; it must
have access to that location. SQL Server will use the SQL Server Service
account to access that location if it doesn't have file level premissions it
will fail.

You do the same thing Tracy recommended by typing the path in the gui,
instead of selecing it from the Tree Listing.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Nick Giordano" wrote:

> Hi,
> It seems that SQL Server does not permit a restore from a non-local drive
> (dataset). Does anyone have a technique to accomplish a restore from a
> non-local drive?
> Thank you,
> Nick
>
>
>