Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Netapp SMVI backup of a running SQL DB

Posted on 2014-09-04
10
Medium Priority
?
510 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 123
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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 123
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 123
ID: 40304360
We trusts and use SMVI, it works for us.....test it!
0
 
LVL 42

Accepted Solution

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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

If your vDisk VHD file gets deleted from the image store accidentally or on purpose, you won't be able to remove the vDisk from the PVS console. There is a known workaround that is solid.
The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
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…
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

664 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