You could, as an experiment, run SQL Server Profiler in the background whilst backing up the database via the GUI. You should be able to see exactly how the GUI...

I don't want to take the wind out of your sails, but have you considered Log Shipping? In previous versions of MSSQL you had to do some scripting (similar to...

I am pretty sure that it doesn't matter if you use DNS name or IP address. Obviously the Port Number is vital, and remember that a Ping test will only...

It sounds like the Distributor is not recognising that a failover has occurred. Have you tried this set up with a Witness Server, and configured it to automatically failover? Bit...

You can also use these System Views:

--built-in Views to monitor Mirroring Status

select * from sys.database_mirroring

select * from sys.database_mirroring_endpoints

select * from sys.database_mirroring_witnesses

select * from sys.dm_db_mirroring_connections

Hi there,

These are the queries I am currently playing around with:

--to retrieve the information shown in the GUI "Database Mirroring Monitor", for a specific database

use msdb

--info under the "Status" tab

exec...

I guess a simple answer is:

1) Create a Stored Procedure which returns a result-set similar to the application you use

2) Create an HTTP endpoint with a webmethod which points to...

Hi Ben,

Your experiences of the civil service / local government could hardly be different to mine! Although I will agree that many services within our particular council could not...

I am currently reading "Pro SQL Server 2005 High Availability", by Allan Hirt, and I just got to chapter 14 on designing high availability solutions - and the exact same...

Many thanks Jacob. Slightly less of a mystery now!

I guess it could and should work, but fault-finding an error would be, err, interesting. Thanks for clarifying.

Andy

Is that a normal set up? Would you have an MSSQL instance within a Cluster, and also have databases running in that instance mirrored to another instance outside of...

erm, you've confused me! Maybe it is just the technical words.

In a Failover Cluster, using Microsoft Cluster Service, each instance of MSSQL is essentially a resource within...

With regards a Witness Server in a Mirror - a failover will only occur if the Witness server cannot connect to the Principal, but can connect to the Mirror.

If,...

Enterprise Manager for MSSQL Server 2000 used to have an option to register the instance in Active Directory - which I guess would create the SPN?

I cannot find the same...