Hi Steve,

Thanks for quick response it is working now. I imagine it can be quite awkward to help when you cannot actually run the query.I just need to...

Hi Steve,

I have just had a go at testing the above script you kindly provided. When I ran it I got the error below:

Msg 512, Level...

Thanks for the suggestion. This is one of the options I am looking at. I am just trying to find a good way to have all the other columns plus...

It had grown as we had run out disk space on the target server.

So if I have the primary and witness servers at our main location and we suffer a power outage will the secondary server automatically takeover?

The systems that I am looking to mirror currently are the management database for our Blackberry Enterprise Server and the configuration database for Active Directory Federation Services. In the event...

Thanks for the info Perry.

So in the event of a power outage at the primary site where the secondary server will lose communication with both the primay and witness server...

You will need to look at Log shipping rather than Mirroring for Sharepoint 2010. As Mirroring will not sync the filestream and BLOB data.

I have now fixed this issue. It seems that even though all 3 instances are on my local machine they need to run with a windows account rather than the...

After investigating further it seems to not be related to when a full backup is taken. It seems to be something to do with either the index optimisation scripts we...