February 11, 2015 at 3:51 am
you could possibly script this but do you want to be blindly adding new databases to availability groups?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 4:18 am
I haven't read through the whole thead, but just want to share my 2ct
- You need to know the difference between Clustering and Always-on !
- clustering: HA solution based on windows failover clustering infrastructure and sharing storage
- always-on: basically advanced database mirroring
- "we don't know what we're doing, but it needs to be high available" i.e. we create database at random, is a dangerous attitude.
resources may get starved jut because someone creates and populates a huge database on the fly.
Maybe Pieters scripts can get you started: http://pietervanhove.azurewebsites.net/?p=3091
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 11, 2015 at 4:33 am
ALZDBA (2/11/2015)
- You need to know the difference between Clustering and Always-on !
My stairway series details this, has been linked and is available on this site
ALZDBA (2/11/2015)
- clustering: HA solution based on windows failover clustering infrastructure and sharing storage
Typically, but not necessarily, alwayson groups seek to remove the shared storage restriction whilst leveraging the WSFC abilities.
ALZDBA (2/11/2015)
- always-on: basically advanced database mirroring
It's a little more involved than that and I'd recommend you read my stairway series, but yes, essentially mirroring on steroids.
ALZDBA (2/11/2015)
- "we don't know what we're doing, but it needs to be high available" i.e. we create database at random, is a dangerous attitude.resources may get starved jut because someone creates and populates a huge database on the fly.
Maybe Pieters scripts can get you started: http://pietervanhove.azurewebsites.net/?p=3091
yes, my point, do you really want to blindly add new databases to availability groups given the availability group restrictions and pre reqs.
You could script it but its a lot of work and too much to go wrong and blow the process, even Peters script are restricted in the number of secondaries and the fact it doesn't actually add any databases, so essentially no good for the OP
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 4:36 am
Perry Whittle (2/11/2015)
ALZDBA (2/11/2015)
- You need to know the difference between Clustering and Always-on !My stairway series details this, has been linked and is available on this site
...
and a great series it is ! :Wow:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 11, 2015 at 6:29 am
ALZDBA (2/11/2015)
and a great series it is ! :Wow:
Thank you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2015 at 7:21 am
Thank you all once again for your inputs !
My dillema is that since our primary instance is not a static instance ( whereas databases are created via the application from a template database , yes i know it's odd ) my only failover solution is this FCI solution.
I will need another site to be replicated also with the primary instance and its newly created databases, but an availability group setup would be an ongoing manual task.
any other ideas and if it's even possible ?
thx
Viewing 6 posts - 46 through 50 (of 50 total)
You must be logged in to reply to this topic. Login to reply