scogeb (10/30/2012)

---

I know when I configure security for a new mirror, the wizard prompts me for credentials to connect to the mirror and witness. I don't think those credentials...

SQLSACT (10/31/2012)

---

Hi Guys

Please help me understand something the Cluster Quorum and specifically Node and Disk Majority

I understand that if you have an even amount on nodes on your cluster, it's...

SQL Server 2012 also supports database mirroring although this feature is now deprecated and marked for removal in...

you asked why you were getting the error, i told you 😉

check the windows application log for more detail

yes, mirror is switched off when indicated to do so under SQL Server 2008 but the mirror partner thinks that the mirror relationship is still in place under 2012

Database mirroring offers...

guerillaunit (10/28/2012)

---

Hello, I am using the following code to try to convert my hexadecimal string to binary format:

DECLARE @MYHEX AS VARCHAR(MAX)

SET @MYHEX = '0000C180880810010000'

SELECT CONVERT(VARBINARY(MAX), @MYHEX, 1)

I get this error...

Indianrock (6/3/2009)

---

You can't run a backup on a log-shipping standby database normally because it's either in no recovery or standby. To reduce the performance hit on our primary server...

Indianrock (6/4/2009)

---

Another DR possibility is stopping the sql service on the log ship standby long enough to copy the data and ldf files elsewhere for attachment. there is a...

Joie Andrew (10/28/2012)

---

On the mirror that you cannot drop (but after it was already removed on the primary), what happens if you issue the following:

RESTORE <database_name> WITH RECOVERY

If it succeeds...

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 files then...

The product itself coupled with books online

you should be able to remove the database using

DROP DATABASE yourdb

This is quite common for contract staff