[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

Is the Server and database being backed up correctly?

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?
0
CTS-Tech
Asked:
CTS-Tech
  • 3
  • 3
1 Solution
 
Danny McDanielClinical Systems AnalystCommented:
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.
0
 
CTS-TechAuthor Commented:
Yes, VMWare Server - not ESXi.
0
 
Danny McDanielClinical Systems AnalystCommented:
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.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
CTS-TechAuthor Commented:
Ended up installing the remote agent on the 2003 virtual server and backup up that way..
0
 
Danny McDanielClinical Systems AnalystCommented:
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.
0
 
CTS-TechAuthor Commented:
Thanks for your help
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now