Solved

Using Backup Exec 2010 for my VM SQL Server

Posted on 2011-03-15
1
932 Views
Last Modified: 2012-05-11
I am currently running Backup Exec 2010 and trying to backup my VM SQL server 2000, I have a SQL agent but when I running the backup it completes with exceptions. I look at my BE Job log and I see the:
V-79-57344-38728  The SQL database 'DataPrep' on virtual machine '\My Server is configured to maintain transaction logs, but transaction log backups are not being performed. Not backing up the transaction log results in the log growing in size until it fills all available disk space. You should either schedule regular log backups or change the database to the simple recovery mode.

In my backup properties for backup method I’m using Full-Backup entire database or file group is this the wrong backup?

0
Comment
Question by:ahmad1467
[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
1 Comment
 
LVL 5

Accepted Solution

by:
VENKAT KOKULLA earned 500 total points
ID: 35141483
Hi,

You can't take a transactional backup if the recovery model is Full. If a database is set in Simple recovery model means, the SQL Engine will automatically truncates the LOG FILE of the Database if its get 80% full. You can use this model, it depends upon your environment, but in this model u can able to restore the point in data loss.

If you are stil not clear, let me know the steps as you are doing with the issues.

--Venkat
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

726 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