• Thanks for the replies but I think I've now got more questions than I had before. What's the best way of checking that clustering, mirroring and replication are set up and running right? We're 'only' the Reporting Team and there's not a massive amount of DBA experience about. We can query the databases and make a beautiful whizzy report to show you pretty much anything you want, but if you ask us how things are running then there's only so much we can do. Yes, there is recruitment going on for a DBA but until then we're a bit in the dark.


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537