How to shrink transaction log files for SharePoint

I found a great post from : SharePoint: How to shrink transaction log file and I was able to follow the instruction and successfully shrink transaction logs for SharePoint database without any problem.  Here is the instruction to shrink transaction logs  files for SharePoint Change the database recovery model to SIMPLE using the next command:Continue reading “How to shrink transaction log files for SharePoint”

How to remove/uninstall SQL Server 2008 from Windows 7/2008

I installed SQL Server 2008 R2 in my Windows 7 to configure SharePoint 2010 as a Farm.  After trying many options, I am still having problem to install SharePoint 2010 in Windows 7 as a farm using SQL Server 2008 instead of SQL Server 2008 Express Edition.  It’s time to remove SQL Server 2008 fromContinue reading “How to remove/uninstall SQL Server 2008 from Windows 7/2008”

SQL Diag Configuration Tool (SDCT)

Download: SQL Diag Configuration Tool (SDCT) SQL Diag is a very useful diagnostic tool that will help capture performance information from SQL Server. This tool is shipped with the SQL Server product. Howerver there is not an easy way to configure the tool – it requires the hand editing of an XML file, which isContinue reading “SQL Diag Configuration Tool (SDCT)”