so you have three datbases on the primary that you are trying to mirror over the the secondary and only one of the three are getting mirrored?

you will have to more specific.

What is the error message that the user is getting? Is the database in a normal \ suspect \ or recovery state? are all...

I also found the issue with trying to restore, the MS artcle does not say that you have to create a master key first. Once I did that I was...

I got the file to write our once taking the sp_addumpdevice off. Now I am unable to get the cert on the new sql server. always problems...

Thank you Gail for...

Yes the drive is valid, yes MSSQLSERVER has rights to write to the drive and no it is not there, I have not been able to ever write the key...

Still getting;

Msg 15240, Level 16, State 1, Line 2

Cannot write into file '\\drive\SQLPrivateKey'. Verify that you have write permissions, that the file path is valid, and that the file does...

It took mine off, serveral times.

However it still is not working. I took the spaces out. I will PM you since my paths are not getting on here correct.

The file path is correct, the post keeps chopping it off.

I took the space out, it dod not work.

USE master;

GO

ALTER DATABASE "mydatabase"

SET RECOVERY FULL;

GO

-- Create mydatabase and MBAM mydatabase devices.

USE master

GO

EXEC sp_addumpdevice 'disk', mydatabase Device',

'\etworkdrive\mydatabase.bak';

GO

-- Back up the full mydatabase. -- This is the script I get the...

Yes, my service account that SQL uses has full permissions to the drive.

GilaMonster (10/22/2013)

---

You can't even do that, a database file for a clustered SQL...

Perry Whittle (10/28/2012)

---

I've recreated this under 2012 and the only way i could remove the broken mirrored db was to stop the SQL Server service and delete the db disk...

4 nodes A\A;

Install Instances

SQL01\INST1

SQL02\INST2

SQL03\INST3

SQL04\INST4

then install the biniares (add node) on each sql server;

biniares for 2,3,4 on node1

biniares for 1,3,4 on node2

biniares for 1,2,4 on node3

biniares for 1,2,3...

coming into this thread late, forgive me Gail if I repeat what you have said,

Why would you put a DB on the C:\ of a clustered SQL server? I would...

Got an answer from MS;

Drop the users in the contained database first, then run the database alter statement, then run the statement on the engine to say 0 contained databases....