通过C＃备份的SQL Server

本文介绍了通过C＃备份的SQL Server的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

多么容易备份通过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