将DB从网络计算机还原到我的PC [英] Restoring DB frm a network computer to My PC

问题描述

我在C＃桌面应用程序上开发了应用程序，SQL 2005作为后端。我在管理员PC和笔记本电脑上安装了应用程序，笔记本电脑访问管理员电脑，该电脑位于同一个网络上。但是，有什么办法可以将管理员PC数据库恢复到我的笔记本电脑，以便在我离开网络时通过连接到我的comp上的SQL来查看数据？现在，场景定义为：网络上的任何计算机都必须从管理员PC访问数据库才能访问任何数据，如果网络中的任何PC（笔记本电脑）离开网络，应用程序将无法工作是没有本地数据库，所以如何导入和恢复数据库管理员我在网络上并将其恢复到我的comp以供将来查看..请帮助。

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.

推荐答案

创建网络数据库的备份并恢复本地系统上的备份。



但是如果你的本地系统上没有sql server（很多人）有sql express）然后你必须在n / w db中创建脚本并在本地执行它们。

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.

这篇关于将DB从网络计算机还原到我的PC的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！