Category Archives: SQL

System Center 2012 R2 Available for downlaod

  Microsoft has added System Center 2012 R2 to the volume licensing site.

Posted in ConfigMgr, DPM, OpsMgr, Orchestrator, SC 2012 R2, SCCM, SCO, SCOM, SCORCH, SCSM, SQL | Tagged , , , , , , , , , | Leave a comment

Cloud Services Process Pack Requirements

When installing the Cloud Services Process Pack SP1 version, I ran into a few issues that are worth noting. On the Orchestrator Server If you don’t have an OrchestratorUsersGroup on the local machine because you selected a domain account during … Continue reading

Posted in Hyper V, SC 2012 SP1, SCORCH, SCSM, SQL, VMM | Tagged , , , , | Leave a comment

How to Monitor SCOM Services with Orchestrator

In my lab I have an issue where SQL doesn’t always start when my VM is rebooted this causes the SCOM services not to start up as well, in our production environment we every once in a while will have … Continue reading

Posted in SCO, SCOM, SQL | Tagged , , | Leave a comment

Follow up to WMF 3.0 and SCCM issues with SQL

Since my original post on issues with the SCCM agent and WMF 3.0. We have only uninstalled the WMF 3.0 update on systems that created major issues or have documented compatibility issues. I have found the WMI queries don’t report SQL Server data correctly. … Continue reading

Posted in Powershell, SCCM, SQL, WMF 3.0, WMI | Tagged , , , , | Leave a comment

SQL Backup Scripts

I needed to setup a one-time backup for all databases on a SQL Server today, normally they are backed up with Veeam and I wanted to have native SQL backups. I found that this query will built the backup commands … Continue reading

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

Bugs with SCCM 2012 And Powershell v3

There is a known bug with the SCCM MP and powershell/WMI v3 if you have the SCCM agent installed on your Management Point Server.  When the SCCM agent health check runs nightly it rebuilds WMI and breaks the MP. Update … Continue reading

Posted in Powershell, SCCM, SQL, WMF 3.0, WMI | Tagged , , , , , , , , | 7 Comments