I report Restore Date from the latest retained msdb history row. My earlier query returned every matching entry.
Recovery Model Changes and the Log Backup Chain
Explain the log backup chain across FULL and SIMPLE changes, inspect recovery LSNs and backup history, and establish a new backup boundary.
Copy Database – SQL in Sixty Seconds #169
At that time I use this technique of copy database while keeping the database online. This method is very simple and efficient.
Multiple Backup Copies Stripped – SQL in Sixty Seconds #156
Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.
SQL SERVER – Creating Multiple Backup Files – Stripped
Multiple Backup Files can form one striped backup set. A customer wanted several files for a single database backup.
SQL SERVER – Check Backup Reliability
Backup Reliability needs a successful restore followed by integrity and application validation. Customers ask whether they can skip that exercise.
percent_complete: Which Commands Show Real Progress
percent_complete tells you how far a running command has come, but only some commands fill it in. This post times eleven commands on SQL Server 2025, shows which ones report real progress and which stay at 0, and adds a way to watch the silent ones.