Tag Archives: SMO

Automating SQL Backup verification testing with PowerShell

Introduction Talk to any person responsible for a database, no matter what platform, and ask them what is their most important responsibility, I would hope that all of them would list backups at the top of their list. Managing these … Continue reading

Posted in Powershell, SQL Server | Tagged , , , , , , | Leave a comment

Making life easy with PowerShell Functions

In my last blog, I showed you how to quickly update the Log retention for SQL server, and made it look even easier by using a Profile loaded function that gets me an instance of a SQL server SMO object … Continue reading

Posted in SQL Server | Tagged , , , , | Leave a comment

Checking Alerts on remote server using PowerShell and SMO

It is common practice to configure a set of alerts across all of your servers. These alerts will cover standard Events (severity 017 – 025) and SQL Server conditions (Log space used etc. ). You can manage these alerts through … Continue reading

Posted in SQL Server | Tagged , , , , | Leave a comment