Server Backup History Report (updated 2006-04-11)

Server Backup History Report (Full DB Backups only) 1. lists all databases with no backup history 2. lists last backup for other databases includes Date, User, Size, Duration, Age, Finish Date & Location Includes system databases Excludes TempDB Excludes backup history data where backupmediafamily.device_type = 7 these are typically created by Veritas BackupExec Tested on […]

4.67 (3)

2006-04-28 (first published: )

4,576 reads

Grant/Revoke EXEC permissions  for all procs in DB

Useful in dev environments when you need to periodically assign execute permissions on all procs in a db (drop/create scripts may have been run without re-assigning permissions)Accepts DB name, ProcLike for matching 'starts with' pattern against proc names in DB, revoke (optional - defaults to 0/True) specifies wheter to GRANT or REVOKE permissions

2002-11-21

387 reads

Blogs

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Daily Coping 23 Sept 2021

By

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

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Read the latest Blogs

Forums

The OPENJSON return schema

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The OPENJSON return schema

Thank a Mentor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thank a Mentor

Create an RPA Flow that Connects to Oracle Data in UiPath Studio

By JerodJ

Comments posted to this topic are about the item Create an RPA Flow that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers