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.

Manage change in a changing environment: aligning ITIL to Office 365

“You never change things by fighting the existing reality. To change something, build a new model that makes the existing model obsolete.” R.Buckminster Fuller Cloud productivity platforms are delivered as constantly changing services. Infrastructure and Operations leaders must manage the impact of this externally driven change on their end users, support structure, IT operations and… Continue reading Manage change in a changing environment: aligning ITIL to Office 365