Solved

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

Posted on 2012-12-20
2
547 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
2 Comments
 
LVL 42

Expert Comment

by:EugeneZ
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

Suggested Solutions

Title # Comments Views Activity
Windows shadowcopy - space allocated - exclusive? 4 27
2016 SQL Licensing 7 41
sql server tables from access 18 18
SQL Count issue 24 14
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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…

776 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