I am in an enterprise that has never deployed a windows failover cluster and our windows team/ad team is scratching their heads with my HA request. My understand is that I as a DBA cannot deploy a HA solution without them first building up the failover cluster. Yes or no? If yes, do you have a video on building this part of the architecture for the purposes of a SQL HA solution? I have watched a few already but they seem to focus on pre-2012 architecture and most of it seems irrelevant now. (eg., multi-node witness vs shared storage, quorum, etc).
Have a question. When I completed the Always-on high availability Wizard. All the server(s) database(s) are all showing (Restoring...) I know I can use scripts to fix this RESTORE DATABASE MyDatabase WITH RECOVERY or RESTORE LOG [MyDatabase] FROM DISK = N'c:\sql\MyDatabase.bak' This is my question? Why does it do this for, and why can't it complete the (Recovering...) on its on? Thanks. Wayne
Hi!, seeing this video gives me a vision of how big "The Database worlds" is !! :D . Also this gives me a reason to learn more. I'm a noob in regards to Database Management and I want to be DBA at the end of the day.. Thanks, PS. Looking for MENTOR's in regards to DBA, willing to learn, but don't have that funds From: Philippines !! God bless !! I hope there would be a tutorial in regards to DBA - road to Hero (DBA)
Excellent presentation. Appreciate the slides and examples
starts at 5:14
I am in an enterprise that has never deployed a windows failover cluster and our windows team/ad team is scratching their heads with my HA request. My understand is that I as a DBA cannot deploy a HA solution without them first building up the failover cluster. Yes or no? If yes, do you have a video on building this part of the architecture for the purposes of a SQL HA solution? I have watched a few already but they seem to focus on pre-2012 architecture and most of it seems irrelevant now. (eg., multi-node witness vs shared storage, quorum, etc).
This isn't 2017 specific. This seems to be a rebroadcast of the SQL 2016 presentation.
Have a question.
When I completed the Always-on high availability Wizard.
All the server(s) database(s) are all showing (Restoring...)
I know I can use scripts to fix this
RESTORE DATABASE MyDatabase WITH RECOVERY
or
RESTORE LOG [MyDatabase]
FROM DISK = N'c:\sql\MyDatabase.bak'
This is my question?
Why does it do this for, and why can't it complete the (Recovering...) on its on?
Thanks.
Wayne
Hi!, seeing this video gives me a vision of how big "The Database worlds" is !! :D . Also this gives me a reason to learn more. I'm a noob in regards to Database Management and I want to be DBA at the end of the day..
Thanks,
PS. Looking for MENTOR's in regards to DBA, willing to learn, but don't have that funds
From: Philippines !!
God bless !!
I hope there would be a tutorial in regards to DBA - road to Hero (DBA)