Viewing 15 posts - 2,746 through 2,760 (of 9,244 total)
adeel.imtiaz (11/15/2014)
Node 1 : windows 2008 R2 + SQL Cluster 2012Node 2 : windows 2008 R2 + SQL Cluster 2012
I highly recommend you use Windows 2012 R2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2014 at 10:29 am
i don't think UK postcodes are an exact measurable science i could be wrong. They are assigned on a street level and one long street will usually have many postcodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 3:43 pm
GraveD (11/14/2014)
We have 2-node SQL Server 2008 R2 Cluster. I'm going to add a new node with SQL Server 2014 and then, after some time, upgrade the cluster to SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2014 at 3:25 pm
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
Viewing 15 posts - 2,746 through 2,760 (of 9,244 total)