I've recently been trained to look after a new Dell Compellent SAN which my company bought so I'd thought I'd share what I'm seeing.

The data in a Compellent is in...

Jeff Moden (9/24/2014)

---

DBA From The Cold (9/24/2014)

---

I've used Idera SQLsafe quite extensively and to be honest, I wouldn't recommend it purely because it's quite memory hungry.

I've seen the program use...

Just a note to say that you can only create server level roles in SQL 2012 and 2014.

Lower versions only have the fixes roles which you cannot change.

OK, it's difficult to provide a resolution with just the information you've provided I'm afraid.

Warning, shameless self plug coming up!

I wouldn't recommend running profiler to capture the deadlock, have a...

You've recovered the database so you cannot restore any more log backups.

Why did you have to RESTORE...WITH RECOVERY between the log restores?

Sorry, I haven't had a chance to look at this.

Did you get the query sorted in the end?

Can you post the deadlock XML (if you have it)?

Please have a look here:-

http://dbafromthecold.wordpress.com/2014/02/11/who-are-your-victims/

It'll show you step by step how to monitor and alert Deadlocks. It'll also show you how to drop the information into a table that you...

Try Perry's recommendation and see if that allows the mirroring to be setup.

The Windows version should not be an issue.

Duran (9/25/2014)

---

Hey, I really appreciate the time everyone has taken to answer this post.

Could you restore the full backup on your secondary server and leave log shipping running, then take...

OK, so the endpoint is there but the user doesn't have permissions to connect

So there's not an endpoint setup. Here's the code to create one:-

CREATE ENDPOINT Mirroring

STATE = STARTED

AS TCP ( LISTENER_PORT = 5023 )

...

Use this to check:-

SELECT

e.name AS [Endpoint Name],

p.STATE AS [State],

CONVERT(SYSNAME, SUSER_NAME(p.grantor_principal_id)) AS [Grantor],

p.TYPE AS [Permission],

CONVERT(SYSNAME, SUSER_NAME(p.grantee_principal_id)) AS [Grantee]

FROM

sys.server_permissions p

INNER JOIN

sys.endpoints e ON p.major_id = e.endpoint_id

WHERE

e.name...

OK, next thing to check is that the account used for mirroring has permissions to connect to the endpoints.

Could you restore the full backup on your secondary server and leave log shipping running, then take a differential backup of your database apply it to the secondary, and then...