Remove 2024 Remove Data Recovery Remove Risk Reduction
article thumbnail

Using T-SQL Snapshot Backup: Point-in-time Recovery

Pure Storage

2121 Created : 9/1/2024 7:34:46 PM Destroyed : False Pod : Source : @{Id='53340721-d581-366f-078d-6d6be001fab3'; Name='SqlServer1-pg'} Space : Suffix : 2121 TimeRemaining : EradicationConfig : @{ManualEradication='enabled'} Id : 7200bda4-b855-9c01-627e-5bf6eeec5a16 Now, it’s time to take a metadata-only backup. No user action is required.

Backup 52
article thumbnail

Using T-SQL Snapshot Backup: Point-in-time Recovery – Azure Edition

Pure Storage

Get-DbaErrorLog -SqlInstance $SqlInstance -LogNumber 0 | Format-Table Sql1 MSSQLSERVER Sql1 9/3/2024 12:37:32 PM spid64 Setting database option suspend_for_snapshot_backup to ON for database 'Database1'. Sql1 MSSQLSERVER Sql1 9/3/2024 12:37:32 PM spid64 Database 'Database1' acquired suspend locks in session 64.

Backup 52