Announcing the PS.SQL Module
I’ve been doing a ton of work with SQL and PowerShell over the last year and a half and have come up with some pretty good tools to help me along the way. We even built a module out of them at work and use it in a dozen or more scripts every day, when it finally occurred to me that my readers might like to use them too. And the PS.SQL Module was born.
SQL Backups Report
This is a simple report to tell you the status of your SQL Server backups.
SQL Backup File Name
As I’ve mentioned, I’m doing a ton of SQL work lately (more on that later!) and I just had a co-worker ask for something so I threw together this quick query. One of our backups had failed and he just wanted to know where the backup file was being placed (in most cases we backup locally but we do have some exceptions). I threw together this query to locate the file name:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT bs.database_name AS Name, | |
| bs.backup_finish_date AS LastBackup, | |
| bmf.physical_device_name AS BackupFile | |
| FROM msdb.dbo.backupmediafamily AS bmf | |
| JOIN msdb.dbo.backupset AS bs | |
| ON bmf.media_set_id = bs.media_set_id | |
| WHERE bs.type = 'D' | |
| ORDER BY bs.backup_finish_date DESC |
I also have a new PowerShell script that reports on SQL backups that I want to get published, as well as a more intelligent index rebuilder that is Availability Group and log shipping aware.
Stay tuned!
Me
LinkedIn
The Surly Admin 