Solved

Netapp SMVI backup of a running SQL DB

Posted on 2014-09-04
10
494 Views
Last Modified: 2014-09-21
will this make a good backup of a running DB SQL 2008 ? ( backend DB for Vcenter)

thanks!!!
0
Comment
Question by:NAMEWITHELD12
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 10

Expert Comment

by:bluedan
ID: 40304193
No. Because Netapp SMVI does not provide Application Consistency backup for SQL database so it will not be a good backup.

Hope this helps.
0
 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 40304220
yeah this does for sure , can you point me to some documentation on this if you can find some  , I need to show my boss!!!!!!


THANKS
0
 
LVL 118
ID: 40304231
We use SAN Snapshots for vCenter Server VM, we do not even Quiesce the VM, it works for us, as the VM is crash consistent!

We've been doing this since 2004, before SMVI was invernted!
0
 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 40304254
Andrew !  thanks , But I am looking to do this on the SQL server that backends the VCEnter , it that ok to do with SMVI?

thanks !!!!!!!!!!!
0
 
LVL 118
ID: 40304264
Yes, we do it with ALL our SQL Servers.......with VMware Snapshot because VMware Snapshots are evil and always fail, and leave a VM running on a snapshot.

So, try it and see if it works for you.,.....
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 1

Author Comment

by:NAMEWITHELD12
ID: 40304307
Andrew , I am not sure I understand , I need to know if we can trust a SMVI back up to restore a running DB or would I want to do a backup from the SQL mananger console on the windows 2008 server as well?


thanks!!!!!!!!
0
 
LVL 42

Expert Comment

by:paulsolov
ID: 40304335
SMVI will do a quiesced consistency state on SQL since it uses MS VSS..but you shouldn't use it as it may cause timeout issues with your SQL Databases if it can't get any quiet time.  You should use Snapmanager for SQL and since most SnapManager products are bundled you probably have this already.  Using SMSQL makes restores a snap (pun intended)
0
 
LVL 10

Expert Comment

by:bluedan
ID: 40304350
You can refer to this link.

https://communities.netapp.com/message/21113#21113

To be safe, I would recommend use both SMVI and SQL mananger console ( For example, schedule a log backup job just right before running SMVI job) or use snapmanager for SQL (if licensed) .

SMVI is great. It can easily recover your entire VM, and If there's issue with SQL DB, you can use the SQL mananger console to roll back the logs to bring SQL up-to-date.

Hope this helps.
0
 
LVL 118
ID: 40304360
We trusts and use SMVI, it works for us.....test it!
0
 
LVL 42

Accepted Solution

by:
paulsolov earned 500 total points
ID: 40304377
The issue with SMVI (especially with iSCSI LUNs out a VM) is the quiet time.  We've seen VSS get bogged down but VMware doesn't know anything about the databases connecting outside of the OS and can cause VMs freeze up and lose connectivity until finished or VMware gives an error of not enough downtime.  If the whole DB/LOG in a single VM and it's not that IO intensive than it works most of the time but if using SMSQL (you can do this on VMDK over NFS)  or ISCSI LUNs you should use SMVI just for the OS (if too busy do not use VSS make it crash consistant) and use SMSQL for the databases as you can recover, test, mount on a different server, etc..  If you have flex clone it makes it even easier.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
Veeam Backup & Replication has added a new integration – Veeam Backup for Microsoft Office 365.  In this blog, we will discuss how you can benefit from Office 365 email backup with the Veeam’s new product and try to shed some light on the needs and …
Teach the user how to install log collectors and how to configure ESXi 5.5 for remote logging Open console session and mount vCenter Server installer: Install vSphere Core Dump Collector: Install vSphere Syslog Collector: Open vSphere Client: Config…
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

911 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

17 Experts available now in Live!

Get 1:1 Help Now