samalex (9/27/2014)

---

I needed to duplicate one of our Production servers in Staging, so I installed a new copy of SQL Server 2012 SP1 on a new Win 2012 box with...

For clarity here's the orignal question

zedtec (9/26/2014)

---

Hi,

I just wanted to ask, if mirroring is set up over a WAN and the internet connection between the sites goes down how does...

It will fail and you'll need to restart the backup from the beginning

depends on...

query the sys.configurations catalog on each server to compare the server level settings

Select name, value_in_use from sys.configurations

i would certainly start by resolving the VLF issue first, in fact when the VLF count gets over a 1000 sql server starts to alert in the error log that...

the fixed database and server roles are exactly that, so no you cant.

You may edit any server or database roles that you create

On the Principal drop the endpoint

--drop endpoint

DROP ENDPOINT PrincipalEndpointName

On the principal, create the windows login for the mirror instances svc account

--Create login

CREATE LOGIN [yourdomain\themirrorsvcuser] FROM WINDOWS

Create the endpoint

CREATE ENDPOINT PrincipalEndPoint

STATE=STARTED...

oskargunn (9/26/2014)

---

This command: GRANT CONNECT ON ENDPOINT....

results in the following error: Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

Should I use a...

Duran (9/25/2014)

---

I think what you are saying is start mirroring then apply log shipping, I had read the article before, but I am already log shipping, that's what make the...

No there isnt a default port but the endpoint is set to 5023 so why are you telnetting to a different port?

SQLJocky (9/24/2014)

---

Does anyone know definitely what the maximum usable character length is for AD objects (users and security groups) to be added as Logins for SQL Server? We want...

ok, the endpoint is using port 5023!!!!

on what ports?

It will also help if you can confirm whether or not there are any...

No, the installer checks the IP address to ensure it is not in use....