Viewing 15 posts - 2,626 through 2,640 (of 9,241 total)
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
Siva Ramasamy (12/8/2014)
I am just going to leave it as it is for now.
Pointless in my opinion, remove it before it fills up too much and then gets cemented in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 8, 2014 at 10:44 am
plamannkathy (12/8/2014)
I have tried doing sql server backups to a file share and that has been taking too long. So I've decided to backup locally and then taking those...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 8, 2014 at 7:04 am
on the SSRS instance properties you will need to enable host headers resolution.
IIS does not and indeed should not be used to manage SSRS instances, the configuration settings are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 8, 2014 at 7:02 am
Viewing 15 posts - 2,626 through 2,640 (of 9,241 total)