Truncate SharePoint Log Files for All the database in SQL Server


Truncate Log Files for All the database in SQL Server1. Perform full backup of all your database2. Open your SQL Management Studio 3. Click on New Query4. Insert the code and click Execute SQL 2008 use masterDECLARE @Statement varchar (4000)SELECT @Statement = ”SELECT @Statement = @Statement + ‘USE [?];’SELECT @Statement = @Statement + ‘DECLARE @Log_Logical_FileNameContinue reading “Truncate SharePoint Log Files for All the database in SQL Server”

Uninstall named instance SQL 2008


How do I remove a named instance of sql server 2008 on the same mssql server? If you have two instance in SQL Server 2008 and what are are the steps to remove one instance from SQL Server? To remove a named instance of sql server 2008, follow these steps 1. Navigate to Control Panel->Add/Remove ProgramsContinue reading “Uninstall named instance SQL 2008”

Microsoft Kerberos Configuration Manager for SQL Server


Source:http://blogs.msdn.com/b/farukcelik/archive/2013/05/21/new-tool-quot-microsoft-kerberos-configuration-manager-for-sql-server-quot-is-ready-to-resolve-your-kerberos-connectivity-issues.aspx You can download “Microsoft Kerberos Configuration Manager for SQL Server” from here Microsoft Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server. Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network.  To use Kerberos authenticationContinue reading “Microsoft Kerberos Configuration Manager for SQL Server”

Install and Configure RBS (Remote Blob Storage) for SharePoint


Where I can download Remote Blob Storage installation files for SharePoint 2010? You can download rbs_x64.msi file from : http://go.microsoft.com/fwlink/p/?LinkID=165839&clcid=0x409 How do I install and configure RBS for SharePoint? 1. Download Remote Blob Storage from above link 2. Before you install Remote Blob storage, make sure SQL server 2008 enabled FILESTREAM. To enable FILESTREAM StartContinue reading “Install and Configure RBS (Remote Blob Storage) for SharePoint”