How to build a Disaster recovery plan in a 2nd AWS region for a small SQL Server DB (30 GB)
I have a Production SQL Server DB (30 GB) in Virginia and I want to have a DR plan in Oregon
I want to have a cold strategy with a full backup (Virginia) and restore (Oregon) done every day at 01:00 and a transaction log backup done every 10 minutes only in Virginia to be restored in the DR site only if a DR event arises
Could you please tell me how Cloudberry tools could help me in this situation?
in a nutshell, the plan is following:
1. Do a full copy of your SQL server (image based) to S3.
2. Then back up your MS SQL DB with MS SQL backup plan.
3. Restore the server as another EC2 instance in the desired region.
4. Create an application load balancer with target instances to your production and your DR instances.
5. Point your users via the load balancer endpoint.
6. Shut down the DR server.
In case of disaster restore, start up your DR server and restore the DB to the latest recovery point available.
Once the DB is restored your users will be able to connect.
RTO should be around 10-20 minutes.
The whole approach to be thoroughly tested before going to production.
Concerning RPO and your statement "restore the DB to the latest recovery point available", what tool do you recommend in order to have a 15 minutes RPO, taking in account that we are have a small DB (30 MB).
Sign in or register to add a comment.
Add a Comment
Welcome to MSP360 Forum!
MSP360 Managed Products
Managed Backup - General
Managed Backup Windows
Managed Backup Mac
Managed Backup Linux
Managed Backup SQL Server
Managed Backup Exchange
Managed Backup Microsoft 365
Managed Backup G Workspace
Backup for Linux
Backup SQL Server
Connect Free/Pro (Remote Desktop)
Issue in Backup Plan creation from RMM (SQL Server)
SQL Server DB was not backed
Cloudberry Backup Trial version not able to select SQL Server
Is it necessary to backup the Microsoft Reserved disk (128MB) on a Windows 2012 R server?
Terms of Service
Useful Hints and Tips
Created with PlushForums
© 2023 MSP360 Forum