通过C＃备份的SQL Server [英] Backup SQL Server via C#

问题描述

多么容易备份通过C＃代码？

How easy is it to backup a SQL Server database via C# code?

我看到很多相关的问题，但没有真正的答案。

I see lots of related questions, but no real answers.

推荐答案

或：生成备份脚本Management Studio中，把它放在一个存储过程，从C＃代码运行程序

Or: Generate your backup script in Management Studio, put it in a stored procedure, run procedure from C# code.

CREATE PROCEDURE sp_backup
AS
BEGIN
    BACKUP DATABASE [YourDatabase] TO  DISK = N'C:\YourPathAndFile.bak' 
    WITH NOFORMAT, NOINIT,  
    NAME = N'Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
END
GO

这篇关于通过C＃备份的SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！