用c#编码进行数据库备份sqlserver2005 [英] c# coding for taking database backup sqlserver2005

问题描述

如何备份数据库并将其保存在D盘中....我需要在一个按钮中编写该代码...同时单击整个数据库以进行备份

how to back the database and save it in D Drive....I need to write that code in one button...while clicking it total database to backup

推荐答案

使用此查询
备份数据库dbName TO DISK =``PATH''
从DISK =``PATH''恢复数据库dbName

use this query
BACKUP DATABASE dbName TO DISK = ''PATH''
RESTORE DATABASE dbName FROM DISK = ''PATH''

尝试以下操作:

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

希望对您有所帮助:)

Try this:

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

hope it helps :)

这篇关于用c#编码进行数据库备份sqlserver2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！