Today we are going to discuss Reclaiming Space and Performance: Database Backup History. I figured out during Comprehensive Database Performance.
SQL SERVER 2022 – Last Valid Restore Time – Improved Backup Metadata
One significant addition to the backup metadata is the inclusion of the last valid restore time. In SQL Server 2022, a new improved backup metadata feature.
11 Essential Tips for Avoiding Common SQL Server Performance Tuning Mistakes
This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.
Compressed Backup and Performance – SQL in Sixty Seconds #196
I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Backup and Performance
SQL SERVER – Sample Script for Compressed and Uncompressed Backup
I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Well, of course.
SQL SERVER – Source Database in Restoring State
A client whom I often help with Health Check recently reached out to me with an interesting problem about Source Database in Restoring State.
SQL SERVER – Get Last Restore Date
Let us learn how to get the last restore date for the backup in SQL Server. Here is a very simple script for the same. Let me know your feedback.