[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Using Backup Exec 2010 for my VM SQL Server

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

873 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