Database

Technical Article

Database Backup Information Scripts

  • Script

Scripts used to validate the backups information as below

1) Database Backups for all databases For Previous Week
2) Most Recent Database Backup for Each Database
3) Most Recent Database Backup for Each Database - Detailed
4) Databases Missing a Back-Up Within Past 24 Hours

4.67 (3)

2015-11-25 (first published: )

1,691 reads

Blogs

Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)

By

Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves...

CosmosDB and Consistency

By

I was doing a little work with CosmosDB recently, and there were a few...

Daily Coping 17 Jan 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Linked Server UPDATE & DELETE fails . But INSERT & SELECTs work fine

By CheBob

Hello, I have a Windows 2019 machine. I have SQL Server 2016 and the...

Extended Events - how can I query the location of File Target of an XE Session?

By Vladimir Isaev

If I know the XE Session name, is there a query to find out...

tricky query with patterns of consecutive rows

By rotcha99

Hi! I'm having struggle with selecting rows, that match "dynamic" rules as described: if...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding Time

See possible answers