Technical Article

List all Databases and Last Full Backups

This script will create a procedure to list all databases on the server (except tempdb), the last time the database was backed up (database backup, not log backups), and a comment which could be customized.  For my purposes, I flag any database which hasn't been backed up in the last week.  This provides a quick […]

5 (1)

2002-06-14

3,104 reads

Blogs

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Do Full Backups Break Log Shipping?

By

TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...

Daily Coping 15 Oct 2021

By

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

Read the latest Blogs

Forums

Disabling all access to the server

By Alex John

Hello everyone! We have a small group of users (4) using MS Access 2000...

How to remove data and index fragmentation in a table

By 892717952

The picture is showing the results that I used sp_spaceused for OldTable and NewTable,...

Database Recovery but DB is 7GB and log file is almost 3

By Vector

I have had a server crash and although I was able to recover the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers