You restore a database from a database snapshot in SQL Server. When the database contains change tracking-enabled tables, the database schema becomes corrupted. Additionally, you receive the following error mes
n ]| <database_snapshot> } 通常用來指定還原備份的來源備份裝置。 另外,您也可以在 RESTORE DATABASE 陳述式中,利用 FROM 子句來指定資料庫所要還原的資料庫快照集名稱,此時不能使用 WITH 子句。 如果省略 FROM 子句,就不會還原備份。 相反地,此時會復原資料庫。 這可讓您復原已利用 NORECOVERY 選項來還原...
如果不存在要还原的数据库,则用户必须有 CREATE DATABASE 权限才能执行 RESTORE。如果该数据库存在,则 RESTORE 权限默认授予sysadmin和dbcreator固定服务器角色成员以及该数据库的所有者 (dbo)(对于 FROM DATABASE_SNAPSHOT 选项,该数据库始终存在)。 RESTORE 权限被授予那些成员身份信息始终可由服务器使用的角色。因为...
RESTORE 参数 (Transact-SQL) 本主题记录了在 RESTORE {DATABASE|LOG} 语句和如后所示的关联辅助语句的“语法”部分中说明的参数:RESTORE FILELISTONLY、RESTORE HEADERONLY、RESTORE LABELONLY、RESTORE REWINDONLY 和 RESTORE VERIFYONLY。大多数参数都仅由这六个语句中的一部分支持。每个参数的说明中都显示了相应的支持...
[;]--To Revert a Database to a Database Snapshot:RESTOREDATABASE{database_name| @database_name_var}FROMDATABASE_SNAPSHOT=database_snapshot_name<backup_device>::={ {logical_backup_device_name| @logical_backup_device_name_var} | {DISK|TAPE|URL} = {'physical_backup_device_name'| @...
(13.x) provides the option to use Azure snapshots for nearly instantaneous backups and faster restores. For more information, seeFile-Snapshot Backups for Database Files in Azure. Azure also offers an enterprise-class backup solution for SQL Server running in Azure VMs. A fully ...
如需有關 SQL Server 還原案例的詳細資訊,請參閱<還原和復原概觀 (SQL Server)>和<實作 SQL Server 資料庫的還原實例>。 [!附註] 如需有關引數之描述的詳細資訊,請參閱<RESTORE 引數 (Transact-SQL)>。 Transact-SQL 語法慣例 語法 --To Restore an Entire Database from a Full database backup (a ...
(13.x) provides the option to use Azure snapshots for nearly instantaneous backups and faster restores. For more information, seeFile-Snapshot Backups for Database Files in Azure. Azure also offers an enterprise-class backup solution for SQL Server running in Azure VMs. A fully manag...
FROM { <backup_device> [ ,...n] | <database_snapshot> } 通常用來指定還原備份的來源備份裝置。另外,您也可以在 RESTORE DATABASE 陳述式中,利用 FROM 子句來指定資料庫所要還原的資料庫快照集名稱,此時不能使用 WITH 子句。 如果省略 FROM 子句,就不會還原備份。相反地,此時會復原資料庫。這可讓您...
The database engine to use for the new instance. This setting doesn’t apply to RDS Custom. Default: The same as source Constraint: Must be compatible with the engine of the source. For example, you can restore a MariaDB 10.1 DB instance from a MySQL 5.6 snapshot. ...