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
AlwaysOn is a great new feature to SQL Server 2012 that allows consuming clients to have a mirroring and failover database solution all transparently for a single named instance. SharePoint is one such consumer of SQL and depends on having a solid connectivity to run. If SQL goes down, so does SharePoint so it’s well… Continue reading SharePoint 2013 and SQL Server AlwaysOn – High Availability SharePoint
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
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.