November 2, 2016 at 3:43 am
Hi,
I've been SQL Server DBA for about a year of 5 small databases.
I've read about high availability and I'd like to practice with this feature.
I understand that no one is going to hand me their precious information just for practice. 😀
My question is: what is a good way or place to practice this feature?
Should I create sql server databases in Azure and create traffic?
Are there training courses for these?
What's your advice?
Thanks.
November 2, 2016 at 5:46 pm
VMs in Azure work well, not the hosted SQL DB (can't set up availability groups on those)
How to practice: Set it up with a sample DB (AdventureWorks or WideWorldImporters) and break one of the servers and see if you can recover.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 2, 2016 at 9:22 pm
Thanks for the advice GilaMonster.
I'll keep that in mind for when the time comes.
November 4, 2016 at 4:47 am
oscarDBA (11/2/2016)
Hi,I've been SQL Server DBA for about a year of 5 small databases.
I've read about high availability and I'd like to practice with this feature.
I understand that no one is going to hand me their precious information just for practice. 😀
My question is: what is a good way or place to practice this feature?
Should I create sql server databases in Azure and create traffic?
Are there training courses for these?
What's your advice?
Thanks.
Work through my stairway to AlwaysOn starting at this link
http://www.sqlservercentral.com/stairway/112556/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply