Monthly Archives: September 2013

ConfigMgr 2012 SSRS fails after upgrade to SQL 2012

I don’t often re-blog other postings, but this particular issue had me puzzled and it is worth giving this exposure. After the upgrade from SQL Server 2008 R2 to SQL 2012, if you check any of the CM SSRS reports, … Continue reading

Posted in ConfigMgr, SQL, SSRS | 3 Comments

Using a PowerShell Script to automate SQL Server database restore

  Recently we moved our remote ConfigMgr 2012 database to our site server. The plan was to leave the existing remote server in place to support the “ad hoc” users. Now, how to refresh that database on a daily basis? … Continue reading

Posted in ConfigMgr, PowerShell, SQL Server | 2 Comments

View Server Last Reboot query

From ConfigMgr, how can I get a list of servers with the last reboot time? Use this query as a starting point, modify as needed, create a report if this information is needed on a frequent basis. SELECT cs.Name0 AS … Continue reading

Posted in SQL, SQL Server | Leave a comment

Moving ConfigMgr 2012 databases between servers

Our CAS was split between two servers; a site server and a dedicated SQL Server. We decided to consolidate the ConfigMgr database to the site server; since the server running SQL Server was underutilized, and it freed up a server … Continue reading

Posted in ConfigMgr, SQL Server | 4 Comments