Solved

Backup strategy for SQL VM

Posted on 2014-02-05
4
25 Views
Last Modified: 2016-05-22
We have SQL2012 (Std.) running on a Windows 2008 VMWare VM. VMs are backed up using Veeam.

SQL server hosts Sharepoint and Exchange databases.

Other than backing up the VM, what other backup strategies should I have in place? I'm thinking really of database backups within SQL.

Should I be using Windows server backup at all?

Thanks for any ideas.
0
Comment
Question by:jostick
4 Comments
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 39837786
use regular Sql server native DBs or 3rd party (Idera, red-gate, etc) ways
you may need to consider point of time db recovery: full backup, diff, translog (For full recovery mode)
you may  plan Always On approach as extra,,


more
Back Up and Restore of SQL Server Databases
http://technet.microsoft.com/en-us/library/ms187048.aspx

Introduction to Backup and Restore Strategies in SQL Server
http://technet.microsoft.com/en-us/library/ms191239(v=sql.105).aspx
0
 
LVL 63

Expert Comment

by:Simon Butler (Sembee)
ID: 39838633
"SQL server hosts Sharepoint and Exchange databases."

SQL doesn't host Exchange. Exchange doesn't use SQL, it has its own database. Therefore unless you have Exchange installed on that server, then you aren't hosting Exchange databases.

To backup Exchange you need to use an Exchange aware backup application. That could be Windows Backup or a third party tool like Backup Assist of Backup Exec.

Simon.
0
 

Author Comment

by:jostick
ID: 39838646
Sorry, it was getting late. I meant SharePoint and CRM!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Read this checklist to learn more about the 15 things you should never include in an email signature.
Viewers will learn how the fundamental information of how to create a table.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question