April 18, 2017 at 2:27 am
Dear All
Complements of the season !!!
I am using MS SQLSERVER 2008 R2, my question is related to High availability of database in case of any disaster. I do take regular backup of DB everyday i.e. after closing of business hours, but during the day if anything happens then i am at risk. Therefore is it possible to replicate all transactions of database on a remote system or any other backup procedures to keep database safe.
Please advice.
Thanks
satish
April 18, 2017 at 2:34 am
Satish
Yes, that's possible. Please start by reading about log shipping and database mirroring. You might also consider upgrading to a more recent version in order to take advantage of newer technologies such as availability groups. Don't forget that high availability is about more than just having a copy of your data - it's about being able to switch over to it with the least possible intervention.
John
April 18, 2017 at 2:41 am
Thanks John for your reply & advice
April 18, 2017 at 8:57 am
Are your databases using the FULL recovery model? In addition to taking full database backups nightly, you should be taking periodic transaction log backups:
https://technet.microsoft.com/en-us/library/ms190440(v=sql.105).aspx
A good place to start thinking about all of this is how much data is the business willing to loose, and how long do you want it to take to recover:
https://www.sqlskills.com/blogs/paul/the-accidental-dba-day-6-of-30-backups-understanding-rto-and-rpo/
April 18, 2017 at 10:24 am
Another thing you could do is look at HA software. Backups are more about DR than HA.
DH2i has a tool called DxEnterprise which handles HA quite nicely as long as you have a secondary server to failover to. It is what we use and I've talked with several other companies who also use this software and are quite happy with it.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply