473,322 Members | 1,566 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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 2044
> 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Robert Tarantino | last post by:
Hello, I am trying to find a way to create a scheduled task or service that will copy my local profile folders under "Documents and settings" to a network drive. This would allow me to restore...
3
by: Tommy.Vincent | last post by:
Hi, its newbie question. I have one production server(A) ,one backup server(B),additional server(C). my database backup are moved from A to C in regular basis. My problem is that when...
2
by: giloosh99 | last post by:
Hello, Im grabbing tables via VB code using visual foxpro ODBC drives. The tables directory is in a mapped network drive. The code works fine and does the job, however if the computer is idle for...
5
by: Niloday | last post by:
Hi All, I am trying to access a mapped network drive from a service that I have created. The service needs to create/delete folders/files on a network drive. When I tried to connect to a...
1
by: brian.oneil2 | last post by:
Is there a way to install this onto a network file share and allow a team to access it? I would say share a CD from a networked CD drive, but there are multiple CD's that would have to be inserted....
8
by: Lam | last post by:
HI anyone knows how can I open a mapped network file in C#? I try string file = @"T:\file.txt"; it shows me the error: "Could not find a part of the path" but if I copy the file to my C dirve,...
5
by: Nirosh | last post by:
Hi All, Can any one suggest me a best way to do this .. I have a thrid party tool "EXE" that we need to use with our web service to manipulate some complex XML files, which reside in a...
3
by: Barry Flynn | last post by:
Hi I am working with a VB 2005 program which has been converted from VB6. It writes data out to a flat file, with code like the following line WriteLine(riFileNo, "Hist", lsAssetID,...
0
by: Now You Know | last post by:
Water Damage Restoration 24 hour open 7 Days Phone 1 877 364 5264 When disaster strikes such as a washing machine overflow, bath overflow, burst pipe, rainwater from balcony etc, water damage...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.