关于SQL SERVER自动备份。

两台服务器,一个作主机,一个备用,两台共用一个硬盘阵列,如何运用SQL语句进行备份数据库文件,数据库密码为空(即sa)。
---------------------------------------------------------------

BACKUP DATABASE databasename to disk = "d:\backup\databasename.bak"
---------------------------------------------------------------

新建作业
---------------------------------------------------------------

你是需要远程备份还是仅仅需要备份到磁盘阵列柜上.
远程备份的话:
BACKUP DATABASE databasename to disk = "\\removecomputer\共享名\databasename.bak"

---------------------------------------------------------------

你在企业管理器里建议JOB即可
---------------------------------------------------------------

建立JOB
BACKUP DATABASE databasename to disk
= "\\机器名\共享名\databasename.bak"

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus