What is in My Database Backup File
The Microsoft SQL Server team has made it easy for you to retrieve the information in a backup file by using a couple of commands. Read on to learn more!
2019-09-03
Database backup
Display the number of days since last Database backup.
A simple T-SQL script to display the number of days since the last database backup.
2013-08-07 (first published: 2013-07-29)
1,651 reads
2014-01-30 (first published: 2012-10-07)
2,105 reads
Blogs
9 questions to ask before adding generative AI to your data project
Will adding generative AI to your data project improve the outcomes? It might, but...
Accelerating Database Modernization Through DevOps & Cloud Integration
By Chris Yates
In today’s enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure...
Speaking at the PASS Data Community Summit
By Steve Jones
I’m honored to be speaking at the PASS Data Community Summit in Seattle this...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Migrate from Linux to Windows with Availability Groups
Comments posted to this topic are about the item Migrate from Linux to Windows...
We Gave Memory-Optimized Tables a Hash Lookup — Then Tried Pattern Matching Instead
Comments posted to this topic are about the item We Gave Memory-Optimized Tables a...
Question of the Day
Always On AG Latency for Read-Only Workload After Failover?
You're responsible for managing a SQL Server environment using Always On Availability Groups across two data centers. During a recent planned failover to the secondary replica, you noticed increased application latency and errors related to read-only routing. Upon investigation, you discover that read-only routing continues pointing to the former primary, now a secondary, for a period of time after the failover.
Which of the following best explains this behavior and how to resolve it?