Changing SSRS database names

I’ve been working on a project where multiple servers including two SharePoint farms running SQL Server Reporting Services (SSRS) in SharePoint Integrated mode need to be moved to a single SQL Server. Each farm has its own SQL Server to host the SharePoint and SSRS databases. To make the job a little more challenging the databases in each farm have the same name. To complete … Continue reading Changing SSRS database names

Data Channel : Managing SharePoint Databases

I was recently interviewed for the Data Channel about managing SharePoint databases on SQL Server. In the interview with Nagaraj Venkatesan (SQL Server MVP from Singapore) I cover many of the common questions DBA’s have about SharePoint including: Things that make SharePoint databases unique Capacity Planning Remote Blob Storage (RBS) Backup / Recovery SSRS Integration Patching You can download a copy of my presentation from #SQLsat614 … Continue reading Data Channel : Managing SharePoint Databases