System Center Data Protection Manager 2016 Delegated Administrator
Andy Dawson Mar 28, 2018 · 2 min read · Data Protection Manager Data Protection Manager DPM DPM Security Security SQL Server SQL Server ·I recently had a requirement to add a delegated administrator to DPM 2016. While it’s possible to configure self-service recovery, there doesn’t appear to be any way that I can configure another user to perform the delegated admin role as there is in some other System Center products. It is possible to configure …
Read MoreTest-SPContentDatabase False Positive
Andy Dawson May 19, 2017 · 1 min read · PowerShell PowerShell Sharepoint Sharepoint Sharepoint Sharepoint SQL Server SQL Server Upgrade Upgrade ·I was recently performing a SharePoint 2013 to 2016 farm upgrade and noticed an interesting issue when performing tests on content databases to be migrated to the new system. As part of the migration of a content database, it’s usual to perform a ‘Test-SPContentDatabase’ operation against each database before attaching …
Read MoreDPM 2012 R2 SQL Backups Failing After November 2014 OS Updates
Andy Dawson Nov 17, 2014 · 3 min read · Backup Backup Data Protection Manager Data Protection Manager DPM DPM SQL Server SQL Server SQL SQL Windows Server 2012 Windows Server 2012 ·Following the installation of the November 2014 OS updates and the updated DPM agent (to update rollup 4) onto a number of servers, I saw failures when attempting to perform a backup of SQL Server 2012 databases hosted on Windows Server 2012. These manifested as ‘replica is inconsistent’ in the DPM console: On the …
Read MoreDuring a recent WSUS upgrade from an old server to a new virtual machine running Windows Server 2008 R2, I saw an issue with the server not downloading updates correctly. The server appeared to synchronise correctly, but then no updates were downloaded. We originally saw an issue like this when we started using …
Read MoreCRM 2011 Update Rollup 6 (and beyond) timeout
Andy Dawson Jul 12, 2012 · 1 min read · CRM Registry SQL Server SQL SQL Windows Server 2008 Windows Server 2008 R2 ·On an instance of CRM 2011 that was being patched to Update Rollup 6 prior to patching to Update Rollup 8, the following error occurred: System.Exception: Action Microsoft.Crm.Setup.Common.Update.DBUpdateAction failed. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to …
Read MoreRenaming the PerformancePoint Service Application database in SharePoint 2010
Andy Dawson Mar 22, 2011 · 3 min read · Deployment PerformancePoint PowerShell SharePoint Sharepoint SQL Server SQL SQL ·When creating the PerformancePoint Service Application, there is no way to control the name of the database that is created, not even when using PowerShell to create the Service Application. The database that gets created is in the form _GUID which for some reason a good many DBAs are not too keen on! The database can …
Read MoreWhat do you think the following post from ADO.NET team blogs says? http://blogs.msdn.com/adonet/archive/2008/10/29/update-on-linq-to-sql-and-linq-to-entities-roadmap.aspx Back in April this year I gave a talk on SQL Server 2008 and one of the aspects I covered was the Entity Framework. It was hard to say at that point …
Read More