Truncate a SharePoint database log file

Since SharePoint is heavily dependent on SQL Server to store not only content but configuration information about the environment, there is a lot of emphasis placed on the design, configuration, scalability and health of SQL Server. One area that we see a lot of questions on is: What should the default recovery model be for…

1

SQL Server Disk Allocation Size

SQL Server is a major component of any SharePoint installation simply because it stores all the configuration, content and really anything SharePoint needs to interact with users.  Given this, sufficient thought should be given to: Disk Partition Alignment so the SQL Server I/O subsystem can perform at it’s best. SQL Server Storage and Capacity Planning…

1

Setup SSRS on a multi server SharePoint farm

In an earlier post I provided step by step instructions on how to install SQL Server Reporting Services (SSRS) on a single server farm.  If you have a large scale farm with several application and web front end servers, not all of them require the SSRS components be installed. The below farm topology illustrates what…


Setup SSRS on a single SharePoint server farm

Installing SQL Server Reporting Services (SSRS) in a SharePoint environment requires several pre-installation steps before you can create the SharePoint service application.  This post is focused on installing SSRS on a single SharePoint server farm.  The topology would be resemble to the following: NOTE:  The SharePoint server contains all roles for the farm (service applications,…


Change IIS Web Application Settings

Once a new web application is created within IIS, changing the settings can be accomplished through the IIS manager but some cannot.  All settings can be changed by using the AppCmd.exe utility. As an example, executing the following command would change the “Default Web Site” name to “Default_1”. C:\Windows\System32\inetsrv>APPCMD set SITE “Default Web Site” /id:1…