Viewing 15 posts - 811 through 825 (of 9,244 total)
Please this Microsoft knowledge base article for more on mirroring and log shipping combined together
https://technet.microsoft.com/en-us/library/ms187016(v=sql.110).aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 5, 2017 at 6:57 am
all 3 nodes must be a member of the same windows server failover cluster, confirm this please
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 5, 2017 at 6:25 am
Time to re visit the database design, normalisation wouldn't go amiss here.
The script itself uses 4 variables of 256 each but the dynamic sql variable is only 999 and mixing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2017 at 11:30 am
a cluster should have an odd number of nodes ideally, you would then use Majority Node Set quorum.
If you have an even number of nodes across multiple data...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2017 at 11:21 am
I just checked and the owner of db file of a critical db server is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2017 at 11:18 am
Good attribute but needs to cover a bit more in depth especially around DNS.
My stairway level on mirror traffic segregation can be found at this link
http://www.sqlservercentral.com/articles/always+on/131901/
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2017 at 12:17 pm
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2017 at 8:53 am
Somewhere up in the above threads you mention a FSW at each site? Could...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2017 at 8:26 am
virtualisation has an overhead, average 10-15%, what ever way you dress it up. There is a software layer interracting with the hardware, the most sensitive and usually the worst performing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2017 at 8:24 am
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2017 at 8:14 am
I support a sql server 2008r2 instance which hosts around 700 databases and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2017 at 9:07 am
we have a curious situation that I can only partially explain.
A SAN that hosts...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2017 at 8:09 am
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2017 at 7:48 am
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2017 at 7:41 am
difficult to say without more info, for this object you can set the norecompute to disable the auto stats updates and juts put in a manual task to handle this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2017 at 7:19 am
Viewing 15 posts - 811 through 825 (of 9,244 total)