Restore All SQL Transaction Logs using Powershell

I came across another opportunity for using Powershell when setting up mirroring for a large database at our DR site. The database was over 73Gig. The problem arose when it took a very long time to copy the backup and transaction logs and run the database restore. By the time the copy had finished another …

Continue reading ‘Restore All SQL Transaction Logs using Powershell’ »

Share

Cycle Those SQL Server Logs

Don’t you just hate it when you open one of your server logs in Management Studio and then you have to wait forever to review it because it never stops reading? I’ve done it enough times and decided to put an end to it or at least greatly reduce the incidence. Using Powershell and a …

Continue reading ‘Cycle Those SQL Server Logs’ »

Share

PowerShell Where Clause – Compare to a list of values

As a databases admin with a few dozen servers and a few hundred SQL Server database, I need to effectively build automated jobs to perform various administrative tasks such as backing up databases. I’m still new to PowerShell but I am beginning to see how immensely helpful it is to me and my work. I …

Continue reading ‘PowerShell Where Clause – Compare to a list of values’ »

Share

Tips & Tricks Using Compare-Object – Copy New Files

This is a wonderful article which not only details the use of Compare-Object but also provides some very excellent examples on its use. Tips & Tricks Using Compare-Object – Dreaming in PowerShell – PowerShell.com I am very new to PowerShell but I am beginning to like using it considerably more each day. I recently had …

Continue reading ‘Tips & Tricks Using Compare-Object – Copy New Files’ »

Share