Shrinking the transaction log of a mirrored SQL Server 2014 database

Well, technically it is possible to shrink a mirrored LOG. What is doing trouble is to backup log with truncate_only. Mirroring doesn’t accept it. So one way is to perform a backup log to disk: USE [DATABASE_NAME]; BACKUP DATABASE [DATABASE_NAME] TO DISK=’E:\Backup\DATABASE_NAME_FULL.bak’ WITH FORMAT; CHECKPOINT; WAITFOR DELAY ’00:00:02′; BACKUP LOG [DATABASE_NAME] TO DISK = ‘E:\Backup\DATABASE_NAME_TL.trn’;… Continue reading Shrinking the transaction log of a mirrored SQL Server 2014 database

SharePoint Url list

To help make life a bit easier for you, we’ve compiled the following table of URLs to help you easily navigate to commonly used settings pages. These work in SharePoint 2013, SharePoint 2010, and (for the most part) SharePoint 2007. Basically, add the URL from the table to the end of the site (or in some cases, the page).… Continue reading SharePoint Url list

Create a Windows Server 2012 Domain Controller and DNS server. Adding DNS server to others existing Windows Servers.

Setting Up Domain Controller Fuctionality Open the Server Manager console and click on Add roles and features Select Role-based of featured-based installation and select Next. Select the Active Directory Directory Services role. Accept the default features required by clicking the Add Features button. On the Features screen click the Next button. On the Confirm installation selections screen click… Continue reading Create a Windows Server 2012 Domain Controller and DNS server. Adding DNS server to others existing Windows Servers.