如何将SQL数据库从一台笔记本电脑导入到另一台笔记本电脑 [英] How To Import SQL Database From One Laptop To Another Laptop

问题描述

大家好……
我和我的朋友当前正在使用Visual Studio 2010作为前端和SQL数据库作为后端进行项目.
由于我们俩都在同一个主题上工作，因此我们在笔记本电脑中都将数据库命名为A和B.
现在，当我第一次从笔记本电脑(例如A)备份数据库并想在朋友的笔记本电脑(例如B)中还原数据库时，我收到了错误消息.
在笔记本电脑B中创建的数据库也会发生相同的情况，并且不会在系统A中还原.
任何人都可以解决这个问题.
目前，我们都有相同的服务器类型，即数据库引擎.
相同的身份验证，即SQL Server身份验证
相同的登录ID，即sa.
但服务器名称和密码不同.

错误消息是
服务器"RAJESHKUMARGUPT"的还原失败. (Microsoft.SqlServer.Smo)

其他信息:
System.Data.SqlClient.SqlError:媒体集具有2个媒体系列，但仅提供了1个.All
必须提供成员. (Microsoft.SqlServer.Smo)

Hello to all......
Me and my friend are currently working on project using Visual studio 2010 as frount end and SQL Database as back end.
As we both are working on same topic so we made database in both laptop say A and B.
Now when i first make a backup of database from my laptop (say A) and want to restore the same in my friend''s laptop (say B),i got the Error message.
The same case occur with the database made in laptop B,and wouldn''t restoring in System A.
Can anyone have a solution of this problem.
Currently we both have same Server type i.e. Database Engine.
same Authentication i.e. SQL Server Authentication
same Login ID i.e sa.
but DIFFERENT Server Name and Password.

The Error Message is
Restore failed for Server ''RAJESHKUMARGUPT''. (Microsoft.SqlServer.Smo)

Additional information:
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided.All
members must be provided. (Microsoft.SqlServer.Smo)

推荐答案

请确保

*您没有任何其他同名数据库.
*您要还原到的数据库名称应输入到数据库字段"中.

Be Sure that

* you don''t have any other database with same name.
* Your database''s name to which you want to restore should be input-ed in, To Database Field

阅读本文:

Read this article: http://cybertext.wordpress.com/2008/02/05/restoring-an-sql-express-database-on-another-computer/[^]
It was very useful for me and I think that could solve your problem.

嘿，您尝试过这个了吗
C:\ Program Files \ Microsoft SQL Server \ MSSQL10_50.MSSQLSERVER \ MSSQL \ Backup
将您的.bak文件粘贴到该位置，然后运行还原过程..让我知道它是否连续...

Hey have you tried this one
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup
paste your .bak file here in that location and then now run the restore process .. let me know if it is successive or not......

这篇关于如何将SQL数据库从一台笔记本电脑导入到另一台笔记本电脑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！