如何每天使用查询自动进行数据库备份sql server200/2005 [英] how to take database backup using query automatically every day sql server200/2005

问题描述

大家好，

我已将Web应用程序作为ABC放置在服务器中，并将数据库放置在另一台服务器中.现在的问题是，我每天早上必须自动进行数据库备份.


请让我知道如何实现它.



谢谢你
mohammad wasif

Hi All,

I have placed web application in a server as ABC and placed database in another server. Now the thing is this i have to take database backup every morning automatically.


Please let me know how to implement it.



thanking you
mohammad wasif

推荐答案

请参见
http://blog.sqlauthority .com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/ [ http://manoranjanmsnet.blogspot.com/2011/01/v-behaviorurldefaultvmlo.html [ ^ ]
使用SQL Server Express安排每日备份 [ ^ ]
http://msdn.microsoft.com/en-us/library/ms175477.aspx [ ^ ]

See
http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/[^]
http://manoranjanmsnet.blogspot.com/2011/01/v-behaviorurldefaultvmlo.html[^]
Schedule a daily backup with SQL Server Express[^]
http://msdn.microsoft.com/en-us/library/ms175477.aspx[^]

这篇关于如何每天使用查询自动进行数据库备份sql server200/2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！