Emergency support can be a bit stressful, especially out of hours on a system you’ve never worked on before.
We recently needed to step in to help a customer who’s 2 node SQL cluster had gone down late one night and managed to get it backup in a few hours after a major disk corruption on the data and logs volume of cluster shared disks taking our the system databases and the user databases. Continue reading Recovering a SQL 2012 cluster from a corrupt master database
As part of some investigations into SQL Server Database Mirroring I did this diagram to show how it works and the pro’s and con’s.
While mirroring is deprecated and will be removed in future versions of SQL server, it is still there in SQL 2014 virtually unchanged and is a good solution for customers with Standard Edition and who can’t or won’t use clustering (SQL clusters aren’t supported in Hyper-V replicas).
Continue reading Poster – Database mirroring in SQL Server 2008 R2
We noted that DirSync wasn’t working for one of our customers, new users weren’t being provisioned in the cloud and there were errors in the event log about FIMS and DirSync.
Continue reading [SOLVED]Office 365 DirSync stops working
We’ve now invited about 30 external people into our SharePoint Online customer sites and have seen this enigmatic error pop up twice. Continue reading Sharing SharePoint online with external user error “Issue Type: Partner User Invalid”
This is a situation we resolved for a customer who was having issues when external people were trying to send to some of their distribution groups.
Continue reading Authentication Error sending to a distribution group on Exchange online
Installing DirSync is not fun, easy or short. Do not make any assumptions about how long it will take to setup. I say this because I spent several wasted hours trying to use the default install and let it install SQL Express automatically and it failed with a whole host of different errors each time I uninstalled, cleaned up and tried again.
Official documentation was either out-dated or used methods which didn’t work, blogs were a mixed bag as well. This post tries to tie the various pieces of correct information together. Continue reading Cut Over Migration and DirSync with Office 365
After a major round of engineering work on a large SQL cluster the DBA’s noted that they were unable to restore databases on one the clustered SQL instances. When they tried they got the following error message:
System.Data.SqlClient.SqlError: Cannot use file ‘’ for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it. (Microsoft.SqlServer.SmoExtended)
Continue reading Error while trying to restore SQL database to a cluster