Solved

Backup strategy for SQL VM

Posted on 2014-02-05
4
22 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

This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
This video discusses moving either the default database or any database to a new volume.

919 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now