如何从Windows窗体中获取SQL数据库备份 [英] How do I take SQL Database Backup from Windows Form

问题描述

您好，



我使用基于Sql Service的数据库成功创建了Windows基础应用程序。



我的应用程序很棒。



我唯一的问题是如何从该应用程序中获取Sql备份

当我解除正常的SQL Sever Backup查询时由于我使用.mdf / .ldf数据库，因此不允许我进行备份。



我谷歌它;它告诉我，我们无法备份.mdf文件。只有这样我们才能复制/粘贴.mdf文件。但它不安全的备份方式;任何人都可以从sql server打开.mdf文件并知道我在其中使用的逻辑。



请帮我解决这个问题。

Hi there,

I successfully create Windows base application with Sql Service-based database.

My application work great.

The only i have problem with "How can I take Sql backup from that application"
When I fired normal SQL Sever Backup query its doesn't allow me to take backup because of I am using .mdf/.ldf database.

I google it; and somewhere it show me we can't take backup of .mdf file. only way we just copy/paste that .mdf file. But its not secure way to take backup; anyone can open that .mdf file from sql server and know which logic i used in it.

please help me out from this problem.

推荐答案

不确定它是否能解决您的问题......但请看一下：用C＃备份SQL数据库 [ ^ ]

我没有尝试使用附加的MDF文件。

Not sure if it'll fix your problem...but have a look here: Backing up an SQL Database in C#[^]
I've not tried it with attached MDF files.

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