Tag Archives: SQL Server

Beware the unmanaged VM snapshots

So, it happened. After 3 years and 4¬†months in my current position, we have corruption! Every DBAs nightmare, right? Now, before I go any further, good planning won the day, and no data was harmed during the making of this … Continue reading

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

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

Scripting Log re-sizing

I know, shrinking log files is bad, but sometimes it is also necessary. Sometimes things go wrong, queries go bad, indexes rebuilds run forever, and any of these events can cause a log file to grow beyond its usual size. … Continue reading

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

SQL Server 2012 automated Install ini Feature list

Any DBA worth their salt will have automated the deployment of any version of SQL server using a SQL server configuration ini and a standard installation script. Through the ini, you can manage exactly what you required to be installed, … Continue reading

Posted in SQL Server | Tagged , , , , , | 6 Comments

Switch Disaster Recovery from Log Shipping to Mirroring

I recently inherited a system on SQL 2005 that was using Log Shipping to sync data to a secondary data center. I am not sure why they decided to use Logs rather than Mirroring, but after a bit of digging … Continue reading

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