Viewing 15 posts - 2,266 through 2,280 (of 9,244 total)
Reg_Mayfield (3/18/2015)
data center and node3 is in another datacenter serving as the DR node.
We...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2015 at 10:47 am
if you're going to be performing any of the backups against readable secondarys your backup scripts will need to employ a certain degree of logic to check which backups already...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2015 at 7:19 am
balasach82 (3/17/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2015 at 4:29 am
mohan.bndr (3/15/2015)
I am still not understanding that why the need of clustering ? and how to achieve the clustering ?Please suggest any body.....Thanks!!
Check out my stairway series on this site...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2015 at 5:53 am
djj (3/16/2015)
In case of failover, while using log shipping, how does the naming convention work? Should our log shipped database have the same name as the production?
A log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2015 at 5:51 am
what does your backup job do, whats the logic built into it?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2015 at 5:47 am
by failing over the AG you are draining the node of any roles it holds
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2015 at 9:01 am
TheSQLGuru (3/11/2015)
Always On is ENTERPRISE EDITION ONLY, and the VAST majority of installed SQL Server in the world is NOT that edition.
AlwaysOn Failover Cluster Instances are not restricted...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2015 at 6:58 am
please don't forget to mark answers as correct as this may help others
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2015 at 11:43 am
Well, the correct way is to use certificated logins and not pass through authentication.
Having said that, if you wish to continue as you are, try creating FQDNs in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2015 at 4:20 am
friedrichsenm (3/10/2015)
I'm planning out how to best deploy an AlwaysOn availability group model in an environment with two separate datacenters (in the same domain) with 2 SQL Server instances in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2015 at 4:12 am
Ste_P (3/10/2015)
Just simply in Management Studio, highlight the primary database, right click - Tasks->Shrink->Files...
I also tried a script that I use occaisionally to shrink all databases and log files...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2015 at 10:31 am
bissagars (3/9/2015)
during msSQL backup we see the disk activity is using 99% approximately 650mb/s , which is using all the RAID 10 speed causing some slowdown with other queries...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2015 at 5:10 am
Hmmm, the message you're seeing is displayed when executing a shrink command against a secondary database.
On my system I run the shrink on the primary and the secondary is taken...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2015 at 4:53 am
they're attempting to shrink the secondary databases files, is that correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 9, 2015 at 5:09 pm
Viewing 15 posts - 2,266 through 2,280 (of 9,244 total)