Viewing 15 posts - 2,626 through 2,640 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2014 at 4:22 am
snomadj (12/8/2014)
I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2014 at 4:15 am
how good is the link between the sites?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2014 at 4:09 am
dmoldovan (11/18/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2014 at 4:08 am
all site management is performed through Reporting Services Configuration manager. You'll need to setup appropriate dns entries and then apply the host header values on the virtual directory config in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2014 at 2:53 am
Viewing 15 posts - 2,626 through 2,640 (of 9,244 total)