Posted by Dan Guzman on 07/01/05 15:14

> So can anyone help me to know what setting should i do in Windows 2003
> server or in SQL Server 2000 to do a network restoration of database.

Ensure the SQL Server service is running under a domain account with
permissions to the share. Use a UNC path rather than a mapped network
drive. For example:

RESTORE DATABASE MyDatabase
FROM '\\REMOTESERVER\BackupShare\MyDatabase.bak'
WITH STATS=10

--
Hope this helps.

Dan Guzman
SQL Server MVP

<Tommy.Vincent@gmail.com> wrote in message
news:1120205182.946293.108160@g43g2000cwa.googlegroups.com...
> Hi,
>
> When i use to work on Windows 2000 advance server and Sql 2000
> I was able to do network restoration by using a mapped drive where my
> backup use to be lying.What i did was I assigned administrator rights
> to my login and in Services (mssqlserver)i added my login.
> Then I was able to access any mapped drive from my network in Sql
> server 2000.
>
>
> Now i have switched my OS to Windows Server 2003.
> What I want to know is , is their any other setting that has to done
> for network restoration , because after following above steps then to I
> am not able to access mapped drive in SQL SERVER 2000.
>
> So can anyone help me to know what setting should i do in Windows 2003
> server or in SQL Server 2000 to do a network restoration of database.
>
> Thanks in advance
> TV
>

[Back to original message]