Solved

how to restore database from network computer to local?

Posted on 2013-11-26
6
260 Views
Last Modified: 2013-11-26
I  am working  with database which resides on test machine .  
I would like to restore it on my local machine , But  when I do backup  in SQL Management Studio- I can  see only  drives of the test machine ,
When I connect my local machine SQL Server Express - I can see drives only my machine.
0
Comment
Question by:Yampolka
  • 3
  • 2
6 Comments
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 39678111
You need to copy the backup file to your local computer before it can be restored.
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 39678114
By default, I believe that the SQL Server service runs as "Local System".  This cannot access networked resources.

Open the services tab and change the owner of the service to be an account that has access to the network resource and stop and start the service.

On a server, you'd usually set up a service account to do it.

If it's your local workstation, you could probably get away with just using your network credentials (the danger with that in a production environment is that when your password expires and you change it, or if you leave you start having issues with authenticating the service on startup).
0
 

Author Comment

by:Yampolka
ID: 39678383
I  cannot access  network computer  where database resides- I do not have network credentials
I can see drives of the network computer only from SQL Management  Studio  when I do restore/ back up operation against database which is in network computer.
When I go to local database on my local computer - I am working in the same SQL Management Studio. But I do not see network computer drives.
What I can do in order to see network computer and my computer  drives ,  when I do backup/ restore operation in  for my local database?
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 22

Expert Comment

by:Steve Wales
ID: 39678410
As stated above, there is a limitation in that access to network resources is limited to the rights that the account that runs the SQL Server service has.

On the network computer, what account runs the SQL Server service ?  I will bet it has access to the network drives.

On your local machine, unless you can come up with permissions (talk to your network administrator maybe?) then your only other real option is to copy the backup files from the remote server to your local machine as stated in the first reply.
0
 

Author Comment

by:Yampolka
ID: 39678453
So  If i cannot  access remote computer to take backup copy?
I see them only in SQL Management Studio but I cannot copy it
0
 
LVL 22

Accepted Solution

by:
Steve Wales earned 500 total points
ID: 39678460
You may need to talk to your network administrator to get permissions you  need ... or have them copy the files you need to a place you can get them
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question