如何自动进行sql server数据库备份 [英] how to take sql server database backup automatically

问题描述

如何自动进行sql server数据库备份。



当系统ON sql server数据库备份必须自动获取并保存在系统中时。





我该怎么办？



请帮助我。



问候，



Narasiman P.

how to take sql server database backup automatically.

when system ON sql server database backup has to be automatically take and saved in the system.


for that how can i do?

Please help me.

Regards,

Narasiman P.

推荐答案

可以通过每日备份...

这可能是解决方案



1. 使用sqlserveragent的自动SQL Server备份工具 [ ^

2. http://www.youtube.com/watch?v=OEgndcJjCs [ ^ ]

It can be possible through Daily Backup...
This may be solution

1. Automatic SQL Server Backup Utility using sqlserveragent[^
2. http://www.youtube.com/watch?v=OEgndcJj-Cs[^]

您可以使用SQL查询执行此操作（另请参阅 http://stackoverflow.com/questions/3741846/query-for-backup-a-database-at-another-location-in -file-system [ ^ ]）：

You can do that with a SQL query (see also http://stackoverflow.com/questions/3741846/query-for-backup-a-database-at-another-location-in-file-system[^]):

BACKUP DATABASE BernieDB TO DISK = 'C:\Backup\BernieDB.bak'

请注意，代码由SQL Server运行的计算机上的SQL Server执行：文件存储在该计算机上。

Note that the code is executed by the SQL Server on the computer where the SQL Server is running: the file is stored on that computer.

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