February 12, 2019 at 7:13 am
Hi firstly I am by no means a db admin, just have a concern of having a database to be available as much as possible.
We have an installation of sql 2017 Enterprise on a physical server. This is a reporting instance in that it will collect data from other sources , transform it and in some ways work as a datawarehouse.
The sources of the data are all on different machines, they are backup up, and they have HA on a different physical server in a different location, so it would seem the live data is looked after. (though this is well out of my remit). Each of the machines works in a virtual environment which switches to another in event of hardware failure. (including the reporting server)
My concern would be the instance and transformed data dbs on the reporting server. My understanding is none of the other physical machines are hosting enterprise. What options do we have for HA? Is it even possible to have HA on one physical server.
Thanks in advance.
February 12, 2019 at 2:52 pm
What are you protecting from? If you have the machine fail, there's no HA. If you think the db files might fail, I guess you could back up and restore in some version of log shipping to a database with storage on different drives/LUN. You could also use replication.
SQL server is unlikely to fail. Any corruption of other issues could be transferred through most HA, so there isn't much you can protect against. The same machine won't have network protection if that fails. It really is only storage.
If you want to protect the reporting stuff, get a second machine/VM.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply