René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Add support for new SQL Server 2022 snapshot backup / restore functionality","articleBody":"SQL Server 2022 introduced a new type of backup - [snapshot](https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-transact-sql-snapshot-backup?view=sql-server-ver16). 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.\r\n\r\n```sql\r\nALTER DATABASE testdb1\r\nSET SUSPEND_FOR_SNAPSHOT_BACKUP = ON\r\n(MODE = COPY_ONLY);\r\n\r\nALTER SERVER CONFIGURATION\r\nSET SUSPEND_FOR_SNAPSHOT_BACKUP = ON\r\n(GROUP = (testdb1, testdb2), MODE = COPY_ONLY);\r\n\r\nBACKUP DATABASE testdb1\r\nTO DISK = 'd:\\temp\\db.bkm'\r\nWITH METADATA_ONLY, FORMAT;\r\n\r\nRESTORE DATABASE testdb1\r\nFROM DISK = 'd:\\temp\\db.bkm'\r\nWITH METADATA_ONLY, FILE = 3, REPLACE, --\u003e no DBNAME clause - restore first database in backup set\r\nMOVE 'testdb1' TO 'd:\\temp\\snap\\testdb1.mdf',\r\nMOVE 'testdb1_log' TO 'd:\\temp\\snap\\testdb1_log.ldf';\r\n```","author":{"url":"https://github.com/arvindshmicrosoft","@type":"Person","name":"arvindshmicrosoft"},"datePublished":"2023-05-31T19:43:02.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/39/SqlScriptDOM/issues/39"}