Archive for July 2013

Powershell: Who is in an Active Directory Group?

This Powershell snippet uses the Get-ADGroupMember to retrieve the names of users in a specific AD group. ?View Code POWERSHELLImport-Module ActiveDirectory; Get-ADGroupMember -Identity "Group Name" | Select-Object Name | Format-Table -AutoSize; Output should look something like below; Name —- Joe Bloggs John Smith Jane Doe

Mirroring SQL Server 2008 R2 Enterprise to Standard

If you attempt to mirror SQL Server 2008 R2 Enterprise to Standard edition, using SSMS, you will receive the following error message; This mirroring configuration is not supported. Because the principal server instance, , is not Standard Edition, the mirror server instance cannot be Standard Edition. You should never mirror between different editions, of SQL […]

Slave: Got error -1 from storage engine Error_code: 1030

I received this error after copying a MyISAM database from one server to another. 130715 15:21:14 [Note] Slave SQL thread initialized, starting replication in log ‘mysqlhost-masterlog.XXXXXXXX’ at position XXXXXX7, relay log ‘/log/binlog/relay-mysqlhostXXXXXX’ position: XXXXXX 130715 15:21:14 [ERROR] Slave SQL: Error ‘Got error -1 from storage engine’ on query. Default database: ‘db’. Query: ‘UPDATE…, Error_code: 1030 […]

Copy SSIS Packages between SQL Server Instances

I’m in the process of setting up a mirrored server and I’m looking to make fail-over as painless as possible. SSIS Packages are used quite extensively in our environment so it would be useful to mirror these. I’ve written a little powershell script to get this done. It’s fairly limited, will only copy packages created […]