Viewing 15 posts - 2,911 through 2,925 (of 9,244 total)
For clarity here's the orignal question
zedtec (9/26/2014)
I just wanted to ask, if mirroring is set up over a WAN and the internet connection between the sites goes down how does...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 6:59 am
kevaburg (9/26/2014)
What happens if I perform a backup over the network and I have an outage?
It will fail and you'll need to restart the backup from the beginning
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 6:09 am
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 this affect database mirroring?
depends on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 5:20 am
query the sys.configurations catalog on each server to compare the server level settings
Select name, value_in_use from sys.configurations
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 5:17 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 5:11 am
the fixed database and server roles are exactly that, so no you cant.
You may edit any server or database roles that you create
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 5:08 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 4:10 am
oskargunn (9/26/2014)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 3:56 am
Duran (9/25/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 8:51 am
No there isnt a default port but the endpoint is set to 5023 so why are you telnetting to a different port?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 8:47 am
SQLJocky (9/24/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 5:15 am
ok, the endpoint is using port 5023!!!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 5:12 am
oskargunn (9/25/2014)
I've also tried to telnet from primary site to mirror site, and that works.
on what ports?
It will also help if you can confirm whether or not there are any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 4:44 am
sandeepkumart (9/24/2014)
Is it possible to configure active/passive sql server cluster instance with the same ipaddress of msdtc?
No, the installer checks the IP address to ensure it is not in use....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 4:20 am
oskargunn (9/25/2014)
No, firewall is disabled on mirror site.
ok what about a secondary firewall, as previously suggested attempt a telnet to the port from the principal server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 4:14 am
Viewing 15 posts - 2,911 through 2,925 (of 9,244 total)