sys.dm_server_suspend_status (Transact-SQL)
Applies to: SQL Server 2022 (16.x)
Returns a row for each database in a suspended state. For more information, see Create a Transact-SQL snapshot backup. Introduced in SQL Server 2022 (16.x).
Column name | Data type | Description |
---|---|---|
db_id | int | ID of the database that is suspended for snapshot backup. |
db_name | sysname | Name of the database suspended for snapshot backup. |
suspend_session_id | tinyint | Identifies the session that suspended the database for snapshot backup. |
suspend_time_ms | bigint | Time elapsed (in milliseconds) since the database has been suspended for snapshot backup. |
is_diff_map_cleared | bit | false if the database has been suspended for snapshot backup in COPY_ONLY mode, true otherwise. |
is_write_io_frozen | bit | true if the write io on the database has been frozen when the database is suspended for snapshot backup, false otherwise. |
Permissions
Principals must have the VIEW SERVER PERFORMANCE STATE permission.
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
BACKUP (Transact-SQL) DATABASEPROPERTYEX (Transact-SQL) SERVERPROPERTY (Transact-SQL)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें