|
Home > Archive > Microsoft SQL Server forum > July 2005 > Restoration From Network Drive
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Restoration From Network Drive
|
|
| Tommy.Vincent@gmail.com 2005-07-01, 3:23 am |
| 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 2005-07-01, 7:23 am |
| > 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\Back
upShare\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
>
|
|
|
|
|