如何在C#中备份数据库 [英] how to backup database in c#

问题描述

如何使用C#编码通过一键式备份数据库来创建备份，一键式以还原到备份.

how to backup database in c# coding through in one button click to crete the backup and one button click to restore to backup.

推荐答案

尝试以下资源-
使用C#和.NET 2.0的SQL Server 2005数据库备份和还原 [ http://midnightprogrammer.net/post/BackupRestore-SQL-database-using-C.aspx [ ^ ]

Try the following resources -
SQL Server 2005 Database Backup and Restore using C# and .NET 2.0[^]
http://midnightprogrammer.net/post/BackupRestore-SQL-database-using-C.aspx[^]
http://www.wisecodes.com/2009/08/code-in-c-to-create-a-backup-of-a-database-in-sql-server-and-restore-it/[^]

一种方法是为此使用SQL.要备份，请执行 BACKUP DATATABSE [还原 [

One way is that you use SQL for that. To backup, execute BACKUP DATATABSE[^] and to restore RESTORE[^]

Hi use below sp



SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[Sp_DatabaseBackup]
as
Begin
DECLARE @name VARCHAR(50) -- database name
DECLARE @path VARCHAR(256) -- path for backup files
DECLARE @fileName VARCHAR(256) -- file name for backup
DECLARE @fileDate VARCHAR(20) -- used for file name
SET @path = ''C:\Users\Publishing\Desktop\''
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)
DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
WHERE name NOT IN (''master'',''model'',''msdb'',''tempdb'')
OPEN db_cursor 
FETCH NEXT FROM db_cursor INTO @name 
WHILE @@FETCH_STATUS = 0 
BEGIN 
SET @fileName = @path + @name + ''_'' + @fileDate + ''.BAK''
BACKUP DATABASE @name TO DISK = @fileName
 FETCH NEXT FROM db_cursor INTO @name 
END 
CLOSE db_cursor 
DEALLOCATE db_cursor 
End

这篇关于如何在C#中备份数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！