April 10, 2014 at 2:25 am
hello friends,
i have a sql server 2008 standard edition installed on a virtual server. This is our production Data warehouse server. This server is being backed up everyday in the evening (virtual backup). This is a data warehouse DB server which is 1TB in size have 5 DB's in total.
Given that we do virtual backups everyday do we also need individual database backups?
What will be the advantage of having individual database backup compared to complete virtual server backup?
This is not OLTP but OLAP purpose database.
Thanks
April 10, 2014 at 2:36 am
If you want backups that you can restore, DB backups would be useful. Depending how they're doing the server image, it may or may not produce usable databases once restored.
Before you can decide on a backup strategy, you need to identify what SLAs you're working with. What's the RPO (or data loss allowance) and what's the RTO (downtime permitted) requirements?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2014 at 2:47 am
You can test your current virtual backpu by restoring on test server or anyother non-production server to make sure in crisses when backup is require you can able to restore as per the agreed dataloss.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply