Skip to content

Chad's Tech

Enterprise Systems Management… ConfigMgr, Intune, PowerShell, and cookies

Menu

  • File Repository
  • Links
  • Resume
  • About

SQL Reporting

You are here: Home » SQL Reporting » Page 2

Huge ReportServer database log

Today I noticed on two of my SCCM 2012 infrastructures that the ReportServer_log.ldf file was extremely large (>100GB).  This is quite concerning considering that the actual database is less than 256MB.  I have not yet investigated the root cause yet,

Chad January 6, 2014March 24, 2020 ConfigMgr, SQL Reporting Read more

SQL Reports Subscription Ownership

We have a number SCCM Reporting Services subscriptions for our automated reporting.  Yesterday I had a former team member’s ID removed from SCCM access and today most of the automated reports did not run. When a report subscription is created

Chad May 1, 2013March 24, 2020 ConfigMgr, ConfigMgr 2007, SQL Reporting, T-SQL Read more

SQL 2012, BIDS, and SSDT

With SQL Server 2012 Business Intelligence Development Studio is replaced with SQL Server Data Tools. BIDS = Business Intelligence Development Studio SSDT = SQL Server Data Tools (http://msdn.com/data/tools.aspx) If you customize SQL Reporting Services reports for SCCM 2007 or ConfigMgr

Chad March 1, 2013March 24, 2020 ConfigMgr, ConfigMgr 2007, SQL Reporting Read more
  • Next »

Recent Posts

  • Fully remove the ConfigMgr client
  • Cleanup System Disk Files
  • Easy IIS log reading for ConfigMgr
  • ConfigMgr: Get primary users with email for a collection
  • Report all ConfigMgr admin console users

Top Posts

  • Azure AD join error code 8018000a
  • Using a Task Sequence Secret Value when changing a local password
  • SCCM 2012 SP1 downloads
  • SCCM backup failing with VSS error
  • Huge ReportServer database log

Tags

Azure AD BitLocker ConfigMgr DFS-R DirectAccess FRS MECM MEMCM Microsoft Intune OSD OS Deployment PowerShell SCCM Scripting Software Packaging SQL SQL Reporting Services SSRS T-SQL WaaS Windows Windows 10 Windows ADK

Categories

  • ConfigMgr
  • ConfigMgr 2007
  • Microsoft Azure
  • Microsoft Intune
  • Microsoft Windows
  • Off Topic
  • Scripting
  • SQL Reporting
  • T-SQL
  • Trackback
  • Uncategorized
  • Windows 10
  • WSUS

RSS

  • RSS - Posts
  • RSS - Comments
Copyright © 2023 Chad's Tech. All rights reserved. Theme Spacious by ThemeGrill. Powered by: WordPress.