如何从FrontEnd备份sql数据库 [英] How to backup sql Database from FrontEnd

问题描述

我们有两个服务器



在一个服务器中，应用程序（ASP.net网站）正在运行，而在第二个服务器数据库（SQL 2005）正在运行..



以前在Same Server上运行的应用程序和数据库都可以使用此命令进行备份



备份数据库TESTDBNAME to disk ='PATH'



有人可以建议我如何摆脱现状



谢谢

We have two Server's

In one server Application(ASP.net Website) is Running and In Second server Database(SQL 2005) is running..

Previously both Application and Database running on Same Server and I can make backup using this command

backup database TESTDBNAME to disk='PATH'

can someone suggest me how i can get rid of current situation

Thanks

推荐答案

在SQL Server中设置预定作业以进行备份。应用程序根本不应该这样做。

Setup a scheduled job in the SQL Server to do that backup. The application shouldn't be doing this at all.

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