Netapp SMVI backup of a running SQL DB

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

Hope this helps.

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

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!

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

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.,.....

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

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)

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.

We trusts and use SMVI, it works for us.....test it!