[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

how to restore database from network computer to local?

Posted on 2013-11-26
6
Medium Priority
?
266 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 23

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
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
LVL 23

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 23

Accepted Solution

by:
Steve Wales earned 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

868 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