Database Snapshot Alternative in SQL MI

• cooldude001

  Mr or Mrs. 500

  Points: 528

  More actions

  April 3, 2024 at 10:25 am

  #4406910

  Database snapshots are not supported in SQL Managed Instance, Is there a workaround for Database snapshot feature.

  Restore from point in time backups will take a lot of time for us.

  I want to create a readonly copy of a database from a specific point, how can this be achieved in SQL MI?

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  April 4, 2024 at 11:10 am

  #4407397

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

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

• webrunner

  SSC-Dedicated

  Points: 31882

  More actions

  April 4, 2024 at 2:24 pm

  #4407475

  Hi, are you looking for something like this?

  https://www.mssqltips.com/sqlservertip/2235/creating-backups-and-copies-of-your-sql-azure-databases/

  HTH

  -- webrunner

   

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html