Solved

Netapp SMVI backup of a running SQL DB

Posted on 2014-09-04
10
506 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
[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
  • 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 120
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
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.

 
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 120
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
 
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 120
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

When ransomware hits your clients, what do you do?

MSPs: Endpoint security isn’t enough to prevent ransomware.
As the impact and severity of crypto ransomware attacks has grown, Webroot fought back, not just by building a next-gen endpoint solution capable of preventing ransomware attacks but also by being a thought leader.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
optimizeing VM 24 98
Are there any problems with using a 5TB external hard drive with Windows SBS2003? 10 108
Two Hyper-V VM server issues 3 46
Unitrends 602 Unit Inherited... 2 40
The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
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 Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

759 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