Tag Archives: Snapshot

Generate SQL Query for Database Snapshot creation using Powershell

Following PowerShell script generates SQL Query to take a snapshot; Advertisements

Posted in Powershell, Productivity, SQL, Uncategorized | Tagged , , , , | Leave a comment

Using SQL Snapshot backups along with Availability group

Snapshot backup is beautiful option during releases and deploying changes specially when the database size is large like few hundreds of GBs. We have a practice to take snapshot backup during the release and delete once testing is completed on … Continue reading

Posted in Productivity, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , | Leave a comment

SQL Snapshot vs Backup – When to choose snapshot over backup

SQL Server backup is my default backup strategy in all situations until yesterday, I never thought of snapshot backups which is definitely a wrong choice. In this blog, I would like to share when I will use snapshot backup in … Continue reading

Posted in Productivity, SQL | Tagged , , , , | 2 Comments