创建数据库快照 (Transact-SQL)Create a Database Snapshot (Transact-SQL)
08/10/2016
本文内容
适用于:Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions)适用于:Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions)
创建 SQL ServerSQL Server 数据库快照的唯一方式是使用 Transact-SQLTransact-SQL。The only way to create a SQL ServerSQL Server database snapshot is to use Transact-SQLTransact-SQL. SQL Server Management StudioSQL Server Management Studio 不支持创建数据库快照。does not support the creation of database snapshots.
开始之前Before You Begin
先决条件Prerequisites
可以使用任何恢复模式的源数据库必须满足以下先决条件:The source database, which can use any recovery model, must meet the following prerequisites:
服务器实例必须运行支持数据库快照的 SQL ServerSQL Server 版本。The server instance must be running an edition of SQL ServerSQL Server that supports database snapshot. 有关 SQL Server 2019 (15.x)SQL Server 2019 (15.x)中数据库快照支持的详细信息,请参阅 SQL Server 2016 各个版本支持的功能。For information about support for database snapshots in SQL Server 2019 (15.x)SQL Server 2019 (15.x), see Features Supported by the Editions of SQL Server 2016.
源数据库必须处于联机状态,除非该数据库是数据库镜像会话中的镜像数据库。The source database must be online, unless the database is a mirror database within a database mirroring session.
若要在镜像数据库中创建数据库快照,数据库必须处于同步 镜像状态。To create a database snapshot on a mirror database, the database must be in the synchronized mirroring state.
不能将源数据库配置为可缩放共享数据库。The source database cannot be co