DBInsight's Blog

Archive for PowerShell

Monthly DBA Maintenance Tasks for SQL Server

This is Jason’s take on the monthly tasks for a SQL Server DBA (10 Monthly Maintenance Tasks for SQL Server). My recommendation is that these tasks should be automated where possible. For example,:- Verifying database backups can be easily automated using Powershell to pick up the latest backups and restore them on a test SQL […]

Continue Reading →

Posted in: DBA, PowerShell, SQL Server Tools

Leave a Comment (0) →

PowerShell for DBAs – Working with INI files

Over the last 3 years I have developed a range of major PowerShell scripts to deploy/configure Replication, SQL Server clustering onto multiple nodes and to perform Database Maintenance tasks (think Ola Hallengren SQL maintenance solution but in PowerShell). Anyway all these major scripts required a large number of configuration parameters and as you would expect […]

Continue Reading →

Posted in: PowerShell

Leave a Comment (0) →

Moving a SQL Cluster using Log Shipping

I recently had the requirement to configure log shipping in a SQL 2008 R2 Standard Edition environment. In my scenario, we needed to move a two node cluster to another floor but also attach it to a new SAN, have minimal downtime, no data loss and use the current server hardware. Database mirroring was not […]

Continue Reading →

Posted in: Database Backups, Log Shipping, PowerShell, SQL Server Tools

Leave a Comment (0) →