Netapp SMVI backup of a running SQL DB

will this make a good backup of a running DB SQL 2008 ? ( backend DB for Vcenter)

thanks!!!
LVL 1
NAMEWITHELD12Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bluedanCommented:
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
NAMEWITHELD12Author Commented:
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
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

NAMEWITHELD12Author Commented:
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
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
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
NAMEWITHELD12Author Commented:
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
Paul SolovyovskySenior IT AdvisorCommented:
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
bluedanCommented:
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
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
We trusts and use SMVI, it works for us.....test it!
0
Paul SolovyovskySenior IT AdvisorCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.