469,268 Members | 961 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,268 developers. It's quick & easy.

Restoration From Network Drive

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

Jul 23 '05 #1
1 1915
> 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

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Robert Tarantino | last post: by
3 posts views Thread by Tommy.Vincent | last post: by
2 posts views Thread by giloosh99 | last post: by
1 post views Thread by brian.oneil2 | last post: by
8 posts views Thread by Lam | last post: by
3 posts views Thread by Barry Flynn | last post: by
reply views Thread by Now You Know | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.