执行期间必须将SQL数据库备份到mdf文件 [英] Have to backup SQL database to mdf file during execution

问题描述

我想在运行时(执行)期间或某个时隙之后将SQL数据库备份到mdf文件中.

有可能吗?

如果是这样，请帮助我.

或通过邮寄方式发送到[已删除电子邮件]

Hi,

I want to backup the SQL database to a mdf file during runtime(execution) or after a time slot.

Is it possible?

If so please help me.

Or mail the way to [email removed]

推荐答案

我想在运行时将SQL数据库备份到mdf文件中(执行)或在某个时隙之后

可能是我误解了，因为无法将备份保存到.mdf文件中，因此将其备份到.bak文件中.

您可以使用SSMS内置功能进行备份，并可以为此设置时间表，

如果有帮助，请 投票 和 接受答案 .

I want to backup the SQL database to a mdf file during runtime(execution) or after a time slot

Probably I think you are misunderstanding something, Because backup can not be taken to .mdf file it is backed up in .bak file.

and you could use SSMS inbuilt function for backup and can set up schedule for that,

Please vote and Accept Answer if it Helped.

签出此链接


http://itknowledgeexchange.techtarget.com/itanswers/how-to -restore-mdf-file-as-bakcup-databe/ [ http://support.microsoft.com/kb/304692 [

check out this link


http://itknowledgeexchange.techtarget.com/itanswers/how-to-restore-mdf-file-as-bakcup-databe/[^]


http://support.microsoft.com/kb/304692[^]

这篇关于执行期间必须将SQL数据库备份到mdf文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！