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
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.