[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Using Backup Exec 2010 for my VM SQL Server

Posted on 2011-03-15
1
Medium Priority
?
937 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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

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.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
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…

650 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