Solved

Using Backup Exec 2010 for my VM SQL Server

Posted on 2011-03-15
1
930 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Present Absent from working date rage 11 49
MySQL limit and not so limited 13 41
Concat multiple records into one line 3 45
MySQL-Design Help 12 44
Creating and Managing Databases with phpMyAdmin in cPanel.
VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
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…

730 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