Viewing 15 posts - 2,746 through 2,760 (of 9,241 total)
enabling FTP also requires the application server features. It's bad practice to host web services on your SQL Server, segregate them always
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 3:16 pm
Grant Fritchey (11/13/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 3:13 pm
TheSQLGuru (11/14/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 3:09 pm
SQL server doesn't tell porky pies, when you get this message it's because an I\O request has taken longer than 15ms. Common with SAN attached disks is storage saturation, but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 2:49 pm
Russell.Morgan-813114 (11/14/2014)
I was referring to AlwaysOn using SQL Server’s existing mirroring technology
Database mirroring basic concept is exactly similar to AlwaysOn groups, they dont require shared storage.
Russell.Morgan-813114 (11/14/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 7:42 am
MyDoggieJessie (11/14/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 7:35 am
Russell.Morgan-813114 (11/14/2014)
I’m about to set up a lab using a network file share to accommodate the shared storage and build this environment.
what do you want shared storage for?
All instances...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 6:29 am
it's the same principal as mirroring from 2012 to 2014 or Log shipping from 2012 to 2014, it's a one time switch due to the version number increase and database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 2:32 am
yes, you can use sql server clustered instances in an AlwaysOn group
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 2:26 am
it'll try so many times then comply with the default policy which leaves the resources offline rather than just constantly attempting restarts. After the default of one hour restarts will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2014 at 2:05 pm
don't forget to check out my stairway series here on SSC too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2014 at 1:08 pm
ramana3327 (11/13/2014)
We are also in the process of migrating to Sql 2014 and setting up always on.
We are concerning about the normal full backup on Alwayson.
Correct me if I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2014 at 9:31 am
Brandie Tarvin (11/12/2014)
I'm getting this last bit from MSSQLTips:this statement seems in direct contradiction to an article Perry Whittle published on this site.
If you scroll down the MSSQL Tips article...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2014 at 9:17 am
when the cluster comes back online the first available node will grab the resources.
If you know you're gioing to have an outage such as that it would be more prudent...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2014 at 9:01 am
with the current quorum configurations available you ideally wont be using a quorum disk, this is the single point of failure. No need to back up the disk as the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2014 at 8:43 am
Viewing 15 posts - 2,746 through 2,760 (of 9,241 total)