Solved

Backup Exec and Agents. (Hyper-v and SQL)

Posted on 2012-12-20
2
551 Views
Last Modified: 2014-11-12
Question...

I'm using Backup Exec to backup a hyper-v server and a few SQL servers. When using the SQL agent and the Microsoft Virtual Server agent, do I also need to backup the .vhds and the sql directories containing the database files/.vhds or does the agent do this for me?

Everything is running fine but I'm having issues as far as space is concerned. Just want to make sure I'm not backing up everything twice.
0
Comment
Question by:someonenamedbrendan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 38709928
it is 2 tasks: sql agent will let you backup to tape directly from sql server (will use native sql server code - in some cases when sql server does not support compression - can be space consuming - in this case 3rd party sql server backup with compression is better solution - backup to NTFS as file- and to the tape (BE sql agent may no need at all)
--
2nd part - check BE documentation:

About managing Microsoft Virtual Hard Disk (VHD) files in Backup Exec
http://www.symantec.com/business/support/index?page=content&id=HOWTO73355

About backing up data
http://www.symantec.com/business/support/index?page=content&id=HOWTO73362#v53893380
0
 
LVL 3

Accepted Solution

by:
gaurav2rawat earned 500 total points
ID: 38714051
BackupExec by default cannot backup same data twice in a backup due to active file exclusion, moreoveryou could use grt feature, with which you have to just install remote agent on the virtual machines and you'llbe able to restore individual files as well as the whole vm's.
For more details go through
http://www.symantec.com/business/support/index?page=content&id=TECH64287
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question