On this page
Lock-free backups do not block
DELETE operations at any point during a backup.
ALTER DATABASE and
SNAPSHOT commands will not run while there is a backup job active on the relevant database.
Lock-free backups are enabled when the
lockfree_ engine variable is set to
ON and the
disable_ engine variable is set to
Lock-free backups cannot be made using
BACKUP DATABASE ..
If lock-free backups are disabled and
BACKUP DATABASE is run, the following applies before the backup starts:
The aggregator briefly blocks new queries from running across the cluster.
If there is a long-running write query executing,
BACKUP DATABASEwaits for the query to complete.
BACKUP DATABASE is running, queries against the cluster can proceed normally.
CREATE TABLE(columnstore and rowstore)
ALTER TABLE(columnstore and rowstore)
DROP TABLE(columnstore and rowstore)
TRUNCATE TABLE(columnstore and rowstore)
DROP INDEX(columnstore and rowstore)
ANALYZE TABLE(columnstore and rowstore)
OPTIMIZE COLUMNSTORE TABLE
SHOW TABLE STATUS
SHOW DATABASE STATUS
OPTIMIZE ROWSTORE TABLE
Last modified: March 13, 2023