如何将数据库复制到另一个位置. [英] How To copy a database to another location.

问题描述

在一个应用程序中，我正在使用一个数据库(例如测试).在我交易结束时.我想将该(测试数据库)复制到另一个位置.我都做完了但是它显示的错误是文件(测试)正在被另一个应用程序nu使用.如何解决这个问题呢.如果您知道，请帮助我.

Hi,
In a application i am using one database (eg.testing). At the end of my transaction over. I want to copy that (testing Database) to another location. I done all. But its showing error as the file(testing) is in use by another application nu. How to solve this problem. If u know help me.

推荐答案

在您PC的SQL Management Studio中....
右键单击所需数据库，然后选择备份....
选择所需的路径并配置名称和所有...
然后单击确定.

然后将该"* .bak"文件复制到所需的PC....
转到该PC的SQL Management Studio ...
右键单击DATABASE并选择RESTORE .........
转到您粘贴.bak文件的路径...
并配置并单击确定..

你做到了........

In your PC''s SQL Management studio....
right click the desire database and select BACK UP....
select the required path and configure name and all...
and click ok.

then copy that "*.bak" file to desired PC....
go to SQL Management studio of that PC......
right click on DATABASE and select RESTORE.........
go to path where u pasted .bak file...
and configure and click ok..

u done it........

在这里，你去了:

使用VB.NET和SQL-DMO(新版本)的SQL Server数据库备份实用程序 [ ^ ]

使用C#和.NET 2.0的SQL Server 2005数据库备份和还原 [

Here you go:

SQL Server Database Backup Utility using VB.NET and SQL-DMO (New version)[^]

SQL Server 2005 Database Backup and Restore using C# and .NET 2.0[^]

这篇关于如何将数据库复制到另一个位置.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！