SQL DR/Backup Solution
Posted on 2014-02-07
I need some advice on a affordable DR/backup solution. We run our production system currently on SQL 2008 Standard. The DB is 70GB and should reach 200GB in the next 3 - 4 years. All our operations is depended on the ERP system that runs on SQL. We are a medium size company so budgets is always a issue.
I currently do 2 full daily backups and a transactional backup every hour. The problem however is the hour of data that we could loose.
If it needs to I can stop the production for 1 - 3 hours and restore an up to date backup. I could probably run transactional backups every 15 min as well, it just gets very complicated to restore then.... and takes a long time.
My biggest concern is not to have any data loss.
I am considering moving over to SQL Server 2012 Business Intelligence Edition