Restoring DB frm a network computer to My PC

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

I have developed application on C# desktop application with SQL 2005 as back end. I installed the application on an admin pc and also on my laptop computer, the laptop computer access the admin pc which is on the same network for the DB. However, is there any way I could restore the admin PC Database to My Laptop so that I can view data by connecting to the SQL on my comp when I am out of the network? Right now the scenario is defined as: any computer on the network has to access the DB from the admin PC in order to access any data and if any PC(laptop) within the network goes out of the network, the application wont work since there is no local DB, so how can I import and restore the DB frm the Admin PC wen I am on the network and restore it to my comp for future viewing.. Please Help.

Posted 15-Apr-13 18:48pm

Member 9936965

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

tumbledDown2earth · Answer 1 · 2013-04-15T23:10:00

Solution 1

create a backup of your network db and restore the backup on your local system.

But if you dont have sql server on your localsystem (many people have sql express) then you have to create the scripts in n/w db and execute them locally.

Posted 15-Apr-13 23:10pm

tumbledDown2earth