如何将数据库复制到给定位置的新数据库. [英] How to copy Database to new database at given location.

问题描述

我想将数据库复制到新数据库并将其保存在给定位置.还告诉我新的数据库名称可以与先前的数据库名称相同吗?

Hi,
I want to copy a database to new database and save that in given location. Also tell me can the new database name is same as previous one?

推荐答案

检查以下文章以进行备份和还原数据库(SQL Server)

http://www.sqlteam.com/article/backup-and- restore-in-sql-server-full-backups [ ^ ]

如果要使用c#进行此操作，请查看以下文章:

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

check the following article for backup and restore database (SQL Server)

http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups[^]

if you want to do this using c#, then check the following article:

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

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