Freezing of multiple databases using VDI snapshot backup command.

• Vivek Luhaniwal

  SSC Enthusiast

  Points: 112

  More actions

  December 31, 2023 at 8:10 pm

  #4354909

  Transact-SQL snapshot backup for SQL Server 2022:

  Suspend all user databases on the server for a snapshot backup:

  ALTER SERVER CONFIGURATION
  SET SUSPEND_FOR_SNAPSHOT_BACKUP = ON;
  
  BACKUP SERVER
  TO DISK = 'd:\temp\db.bkm'
  WITH METADATA_ONLY, FORMAT;

  METADATA_ONLY is synonymous with SNAPSHOT. The Virtual Device Interface (VDI) uses SNAPSHOT.

  VDI Snapshot backup:

  Backup statement:

  BACKUP DATABASE {database_name} TO VIRTUAL_DEVICE='' WITH SNAPSHOT

  The BACKUP command supports the 'WITH SNAPSHOT' option to be used with virtual devices. An application issues the BACKUP DATABASE command and then interacts with the server through the Virtual Device Interface (VDI) to capture the backup set meta data and perform the snapshot. Only meta data is transferred to the application.

  How to freeze multiple databases using VDI WITH SNAPSHOT similar to Transact-SQL snapshot backup for SQL 2022?

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  January 1, 2024 at 9:10 pm

  #4355284

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.