IMHO backup jobs should be running on the mirror, they should at least be intelligent enough to skip databases that are not online.

The mirror may not always be a dedicated...

what operating mode are you using for your mirror session?

do you have a witness server?

why cant you create a windows account and use that?

Manie Verster (6/10/2013)

---

You have chosen to link a rather ancient article that covers SQL Server 7.0, 2000, 2005 which is no longer relevant. Under SQL Server 2000 you had to...

As i pointed...

All detailed here[/url] and here[/url]

Jai-SQL DBA (6/10/2013)

---

name KeyEncBySrvr

------ --------------

masterEncrypted by SMK

namepvt_key_encryption_type_descissuer_namesubject

---- ---------------------------- ----------- ...

Ok so have a stab, what can you learn from the results?

What do the following queries return?

selectname

, CASE is_master_key_encrypted_by_server

WHEN 0 THEN 'Encrypted by password only'

WHEN 1 THEN 'Encrypted by SMK'

END AS KeyEncBySrvr

from sys.databases

where name = 'master'

selectname

, pvt_key_encryption_type_desc

, issuer_name

, [subject]

from...

A typical create master key command

USE master

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'

A typical create certificate command

USE master

CREATE CERTIFICATE MyServerCert WITH SUBJECT = 'My DEK Certificate'

A typical create database...

The database master key is independant of the certificate. The master DMk is merely used to protect the private key while the cert is stored on the SQL server.

The...

My 3 part guide is a good source, they're linked below

Part 1[/url]

Part 2[/url]

Part 3[/url]

Read my article it will expalin in more detail.

Vlad-207446 (6/10/2013)

---

but if you have to physicaly move the files your self anyway, than wouldn't just

stop...

in asynchronous mode the only way to perform a failover between partners is to use the following

ALTER DATABASE [somedb] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

As Lynn says, data could be lost so a...

detailed here