admin 管理员组文章数量: 1184232
2024年4月18日发(作者：ospf防环机制)
sql server的备份语句
英文回答：
Basic syntax for backing up a database.
sql.
BACKUP DATABASE database_name.
TO disk_file_path.
WITH (。
[option] = value,。
...
)。
Options for the WITH clause.
The following options can be used in the `WITH` clause:
NAME: Specifies the name of the backup file.
DESCRIPTION: Specifies a description for the backup
file.
EXPIRY_DATE: Specifies the date when the backup file
will expire.
COPY_ONLY: Creates a copy-only backup, which cannot be
restored.
NORECOVERY: Creates a non-recoverable backup, which
cannot be used to restore the database.
STANDBY: Creates a standby backup, which can be used
to create a read-only replica of the database.
CHECKSUM: Computes a checksum for the backup file.
版权声明：本文标题：sql server的备份语句 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.roclinux.cn/p/1713401143a632731.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论