Viewing 15 posts - 2,626 through 2,640 (of 9,253 total)
snomadj (12/10/2014)
a) when P is P
When the mirror and witness are down the principal is running exposed and as a result goes offline
snomadj (12/10/2014)
December 10, 2014 at 8:19 am
JoshDBGuy (12/9/2014)
Perry Whittle (12/9/2014)
JoshDBGuy (11/26/2014)
So will this also work,
if (select ars.rolefrom sys.dm_hadr_availability_replica_states ars
where ars.is_local = 1) = 2
begin
raiserror ('This is not the primary replica.',2,1)
end
Work from where, where will this be...
December 10, 2014 at 8:02 am
Never applied TDE to a mirror, cant see why this won't work though
You'll need to create a database master key on each instance if one doesn't already exist.
Once this is...
December 9, 2014 at 4:11 pm
the certificate is stored in the master database and can be used for all databases or you could have multiple server certs and use different ones to secure DEKs within...
December 9, 2014 at 4:04 pm
JoshDBGuy (11/26/2014)
So will this also work,
if (select ars.rolefrom sys.dm_hadr_availability_replica_states ars
where ars.is_local = 1) = 2
begin
raiserror ('This is not the primary replica.',2,1)
end
Work from where, where will this be running from? Did...
December 9, 2014 at 10:01 am
JoshDBGuy (12/9/2014)
So he created multiple LUNS for our environments.
yes but are they dedicated for the VM or has the ESX admin created an ESX data store on them?
JoshDBGuy (12/9/2014)
December 9, 2014 at 9:58 am
the certificate is applied and the encryption is enabled in sql server configuration manager instance wide. The certificate is stored in the machines local store.
If you want to use policy...
December 9, 2014 at 9:04 am
What HA are you thinking of using?
The scenario i used was log shipping a large database from UK to USA.
December 9, 2014 at 8:06 am
alex.sqldba (12/9/2014)
I am a bit confused by certificates and SSL in SQL Server.
Are they one and the same thing?
For example one can create a certificate in sql server...
December 9, 2014 at 5:19 am
i've done it before, it may take a short while but you only need the initial full to start any HA. Just remember to factor into any reinitialisation scenario the...
December 9, 2014 at 4:47 am
getting your mates to ask the same question are you??
http://www.sqlservercentral.com/Forums/Topic1642361-391-1.aspx
December 9, 2014 at 4:22 am
snomadj (12/8/2014)
I...
December 9, 2014 at 4:20 am
something on your network has the same IP address as another resource, make a check of all IPs in use
December 9, 2014 at 4:15 am
how good is the link between the sites?
December 9, 2014 at 4:09 am
dmoldovan (11/18/2014)
December 9, 2014 at 4:08 am
Viewing 15 posts - 2,626 through 2,640 (of 9,253 total)