本文介绍了通过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更多推荐
通过C#备份的SQL Server
发布评论