Lock-free Backups
On this page
Lock-free backups do not block INSERT, UPDATE, and DELETE operations at any point during a backup.
However, ALTER DATABASE and SNAPSHOT commands will not run while there is a backup job active on the relevant database.
Commands Blocked by the BACKUP Process
-
ALTER DATABASE -
DROP DATABASE -
SNAPSHOT DATABASE
Commands Not Blocked by the BACKUP Process
-
CREATE TABLE(columnstore and rowstore) -
ALTER TABLE(columnstore and rowstore) -
DROP TABLE(columnstore and rowstore) -
DELETE TABLE -
INSERT TABLE -
TRUNCATE TABLE(columnstore and rowstore) -
CREATE INDEX -
DROP INDEX(columnstore and rowstore) -
CREATE VIEW -
DROP VIEW -
ANALYZE TABLE(columnstore and rowstore) -
OPTIMIZE COLUMNSTORE TABLE -
SHOW TABLE STATUS -
SHOW DATABASE STATUS -
OPTIMIZE ROWSTORE TABLE
Last modified: February 29, 2024