嗨大家好,
我在设计的一部分,我需要允许我的结束 - 用户创建我系统中创建/提供的所有数据的备份。这是非常重要的,以便在任何前所未有的事件造成系统撤销的情况下,会有成为恢复数据丢失的一个点。
I'm on a part of my design where I need to allow my end-user to create a backup of all data created/supplied in my system. This is a very important so that in case of a systemback-down caused by anyunprecedentedevent, there would be a point where to recover data lost.
查询:
1。我应该在创建数据备份时应该处理哪些重要文件,它是"ApplicationDatabase.mdf"吗?或其他任何其他?
1. What significant files should I supposed to deal in creating backup of data, Is it the "ApplicationDatabase.mdf" or any other else?
2。论坛中是否有任何帖子可以解决这个问题?
2. Is there any previous post in the forum that tackles this problem?
3。或者任何人都可以给我一个如何做的提示。
3. Or could any one can give me a hint on how to do it.
考虑我的系统将以小规模部署办公室只使用工作组中的共享数据,并且可能需要每周备份数据。
Consider that my system would be deployed in a small scale office where it uses only a shared data in a workgroup, and needs maybe to backup data weekly.
非常感谢您的帮助。
Nante
推荐答案
Hi Nante,
Hi Nante,
是的 - SQL Server数据库是您想要支持的最重要的事情up。
Yes - the SQL Server database is the most important thing that you want to back up.
这是上一篇文章,简要提到了这一点。
Here's a previous post that briefly mentions this.
social.msdn.microsoft/Forums/en-AU/lightswitchgeneral/thread/d3122112-23e7-411c-a715-7dd4140f3f48
这是SQL Server的帮助创建数据库备份。
Here's the SQL Server help on creating database backups.
msdn.microsoft/en-us/library/ms175477.aspx
如果您已将系统部署到SQLExpress上,SQLExpress不包含SQL代理,这使得备份自动化变得困难。以下是如何解决此问题的链接。
If you've deployed your system onto SQLExpress, SQLExpress doesn't include SQL agent which makes it difficult to automate the backups. Here's a link on how to work around this.
http:// dotnettim.wordpress/2011/04/05/sql-server-run-scheduled-scripts-without-sql-agent/
Tim
更多推荐
如何在LS中创建数据备份?
发布评论