Episode 259: T-SQL Snapshot Backups

SQL Data Partners Podcast

Content provided by Marathon Consulting and Carlos L Chacon. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Marathon Consulting and Carlos L Chacon or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

1+ y ago 27:46

MP3•Episode home

We kick off the new year discussing a new feature in SQL Server 2022 called Transact-SQL snapshot backups. Good luck with the Google search on this feature--we know we had fun. 😊 These are not the snapshot backups you were frustrated with in 2005. We talk a little bit about who will be interested in this feature and what scenarios it will come in handy. The hardware vendors seem particularly excited about this future as they can now introduce snapshots without needing a third-party application like Veeam to do that for them. We predict more collaboration between the database administrator and the hardware administrator with this feature. We also get a couple of use case scenarios from the community that we share in this episode. Are you looking forward to using snapshots more effectively in your environment? Please let us know your thoughts!

The show notes and video for this episode can be found at https://sqldatapartners.com/2023/01/18/episode-259-t-sql-snapshot-backups/. Have fun on the SQL Trail!

276 episodes

#Data Science #Science #Databaseadministrator #Dataprofessional #Sqlserver #Carlos L Chacon #Powerbi #Tech #Software Development #Podcasting Education