Add support for new SQL Server 2022 snapshot backup / restore functionality

Open

#39 opened on May 31, 2023 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty: 4/5
Estimated time: 3-5 days
Newbie friendliness: 35/100

Issue type: Feature
Clarity: Mostly clear
Activity status: Stale
Tech stack: sql
Domain: databases

Research direction

Start with the SQL Server snapshot backup documentation linked in the issue and compare its examples with ScriptDOM's current parsing behavior. Check the listed ALTER DATABASE, ALTER SERVER CONFIGURATION, BACKUP, and RESTORE statements, including their new options. Done means the shown snapshot backup and restore syntax is recognized by ScriptDOM without confusing it with database snapshots.

Written by the indexing model from the issue text.

Description

enhancement sql-feature

SQL Server 2022 introduced a new type of backup - snapshot. ScriptDom currently does not support this type of backup. Note that this is different from the database snapshot functionality, which has been around since SQL Server 2005. In addition, there are new statements (BACKUP GROUP and BACKUP SERVER) in SQL Server 2022 which work in conjunction with these snapshot backups. There are also new options like SUSPEND_FOR_SNAPSHOT_BACKUP for ALTER DATABASE and ALTER SERVER CONFIGURATION, which are not recognized by ScriptDom. Example of statements which should be handled by ScriptDom are below. There are more examples in the docs linked to earlier.

ALTER DATABASE testdb1
SET SUSPEND_FOR_SNAPSHOT_BACKUP = ON
(MODE = COPY_ONLY);

ALTER SERVER CONFIGURATION
SET SUSPEND_FOR_SNAPSHOT_BACKUP = ON
(GROUP = (testdb1, testdb2), MODE = COPY_ONLY);

BACKUP DATABASE testdb1
TO DISK = 'd:\temp\db.bkm'
WITH METADATA_ONLY, FORMAT;

RESTORE DATABASE testdb1
FROM DISK = 'd:\temp\db.bkm'
WITH METADATA_ONLY, FILE = 3, REPLACE, --> no DBNAME clause - restore first database in backup set
MOVE 'testdb1' TO 'd:\temp\snap\testdb1.mdf',
MOVE 'testdb1_log' TO 'd:\temp\snap\testdb1_log.ldf';

Dominant language: GAP
Stars: 277
Forks: 43
Avg merge: 6d 17h
Merged PRs (30d): 3

Contributor guide

Open the contributing guide

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Similar issues

[Bug report] iceberg rest server load_table with refs fails precondition check "Cannot set metadata location with changes to table metadata: %s changes" for snapshots with statistics Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 85/100

apache/gravitino#13452 · Opened Sep 22, 2026
[BUG]: "Clear All" in Settings doesn't clear the saved analysis, old data comes back after reload Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

AOSSIE-Org/OrgExplorer#253 · 1 comment · Opened Sep 22, 2026
doltlite_vtab_vc_matrix.sh asserts the pre-merge state after a clean merge, so a refused merge passes Open

enhancement

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

dolthub/doltlite#3163 · Opened Sep 22, 2026
[receiver/oracledb] db.system.name emits "oracle" instead of the semconv value "oracle.db" Open

needs triage receiver/oracledb

Difficulty 2/5 1-2 days Newbie friendliness 84/100

open-telemetry/opentelemetry-collector-contrib#51400 · 1 comment · Opened Sep 22, 2026
Default properties (especially URLs) have the wrong type: string instead of url Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

logseq/db-test#1264 · Opened Sep 22, 2026

More Databases issues