We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Is the Server and database being backed up correctly?

CTS-Tech
CTS-Tech asked
on
Medium Priority
450 Views
Last Modified: 2012-05-11
We have a SBS 2008 Server, that runs a database application on a VMWare Virtual Server (Server 2003).  We want to make sure the database and anything else important on the Virtual Server is being backed up correctly.

Previously, the SBS Server had Acronis True Image SBS installed and was doing a nightly image backup of the entire Server.  I’m not sure if that was backing up the Virtual Server correctly, with the Server running and database live.

Now, Backup Exec SBS 2010 R2 has been installed.  We are backing up everything on the C: drive, but I'm still not sure if the live Virtual Server is backing up correctly.

Do we need to shut down the Virtual Server while the backup is running to ensure a correct backup?  Do we need to do a separate database backup from the Virtual Server to the SBS Server if we want to keep the Virtual Server up?
Comment
Watch Question

Danny McDanielClinical Systems Analyst

Commented:
Just to confirm... you are running VMware Server and not VMware ESX(i), correct?  VMware Server run's on top of a Windows or Linux system just like any other application.  ESX(i) installs directly onto the hardware with no other underlying OS and you manage it from another system.

If you are using VMware Server, then you will want to use a backup utility that is aware of VMware Server so it can take a snapshot of the running virtual machine so the virtual disk base file is not busy.  If it's not aware of Server, then you can always script something to do this for you, too.

Author

Commented:
Yes, VMWare Server - not ESXi.
Danny McDanielClinical Systems Analyst

Commented:
I would recommend you do a seperate sql backup, especially if you aren't using simple recovery on the db.  That way the transaction logs will keep pared down and you can more easily restore the db to another server if need be.
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Danny McDanielClinical Systems Analyst

Commented:
that method will work, too, it just might take longer to do a restore from scratch but if you don't have very many virtual machines then it it's hard to justify the additional expense/work it would take to do it the other way.

Author

Commented:
Thanks for your help
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.