Restoration From Network Drive

[Tommy.Vincent]

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

[Dan Guzman]

> 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

<To***********@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.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