Solved

Backup strategy for SQL VM

Posted on 2014-02-05
4
20 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
Comment Utility
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)
Comment Utility
"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
Comment Utility
Sorry, it was getting late. I meant SharePoint and CRM!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

772 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

10 Experts available now in Live!

Get 1:1 Help Now