SQL MI - DB Snapshot Alternative

• MissTippsInOz

  Hall of Fame

  Points: 3160

  More actions

  February 23, 2022 at 11:08 pm

  #3987715

  We are about to migrate our on-prem SQL boxes to Managed Instances and currently use database snapshots for various reasons. They are unsupported in MI and I wondered whether anyone had found a creative alternative?

  Thanks

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  February 24, 2022 at 1:48 pm

  #3988258

  I am not aware of any.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning