April 15, 2008 at 8:44 am
Hi, I've set up a couple of servers (no witness) in a test environment to look at DB mirroring. All seems ok until I try and do a test failover!
To test this I want to use a real world example, so I've just shut SQL on the principal server, as what might happen in a live situation and after all what this is set up for in the first place. I dont want to do a manual failover.
The principal is therefore not available so how do I now open it up to take connections. Every time I run a query against it I get - 'Database ccr is enabled for Database Mirroring, but neither the partner nor witness server instances are available: the database cannot be opened'. Or when I try to run 'alter database ccr set partner = 'FORCE_SERVICE_ALLOW_DATA_LOSS' I get 'invalid server connection string'.
Any ideas please?!?!? As I say i dont want to test a manual cutover. I want to test what I need to do when the principal is not available. Also I won't have a witness available at anytime.
Thanks
April 16, 2008 at 9:57 pm
Get rid of the "=" from the statement. It should read:
[font="Courier New"]ALTER DATABASE SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS[/font]
Assuming that you were posting verbatim to this forum what you were typing in SSMS of course.
Make sure you are running the command from a connection to the mirror server, not the principal.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
April 17, 2008 at 3:00 am
Hi Scott, thanks for your resposne. Yes I was trying exactly what I'd typed. I had tried this just a few hours ago actually and like you say had to remove the = syntax. And the quotes I'd used.
Thanks very much for confirming tho.
Cheers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply