How to back up SQL 2012 that is running in a VM

Physical server is a Windows 2012 server non-R2 running Hyper-V. I have a Windows 2012 non-R2 guest running SQL 2012. Would it be recommended to protect SQL 2012 using the Hyper-V component of Windows Server Backup run from the Host?
CanOfWormsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

Kash2nd Line EngineerCommented:
we have an SQL server.
We has a NAS LUN provisioned for it which is passed to the Virtual Machine and then use Windows server Backup to do a backup of it.

A second layer we have to backup the whole SQL VM using host's backup software.
Kash2nd Line EngineerCommented:
for SQL Database backups, you can use SQL Maintenance Plans
Deepak ChauhanSQL Server DBACommented:
Which edition of sql server you are using?
1. You can create inbuild Maintenance plan in SQL server 2012 Enterprise edition \ Standard Edition.
2. You can create SQL server agent job with Tsql backup script task and schedule at any time.

In case edition is Express. you can not create Maintenance plan \ SQL agent job ,
you have to save the Tsql script in .sql file
create a bat file which will call to SQLCMD to execute this script.
Schedule the bat file using Windows task manager.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

CanOfWormsAuthor Commented:
Thank you for your comments. I would like to use only the Host backup of the VM if that would be a reliable way to backup SQL 2012 Standard.

What I am seeing is for reliable backups of the SQL DB we must run a backup from within the VM. Is this the case? Thank you for your thoughts.
Deepak ChauhanSQL Server DBACommented:
SQL DBs should be backed up on daily basis via SQL Native method or any third party tool like Symentec Backup exec.

I would suggest, you should go with SQL native backup especially for SQL databases.

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
CanOfWormsAuthor Commented:
Thank you for your clear perspective.
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
Windows Server 2012

From novice to tech pro — start learning today.