?
Solved

Backup strategy for SQL VM

Posted on 2014-02-05
4
Medium Priority
?
38 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 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

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

A list of top three free exchange EDB viewers that helps the user to extract a mailbox from an unmounted .edb file and get a clear preview of all emails & other items with just a single click on mailboxes.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

770 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