Solved

Transaction Logs and Backups

Posted on 2011-03-21
2
710 Views
Last Modified: 2012-05-11
Hello,

I'm working with a new client where he has a SQL server running an accounting program. I configured Backup Exec to backup the database, but I get the following error when backups finish.

"Database BankData is configured to maintain transaction logs.  Transaction log backups are not being performed.  This will result in the log growing to fill all available disk space.  Regular log backups should be scheduled or the database should be changed to simple recovery mode."

Is this something I configure in Backup Exec or SQL Server?
0
Comment
Question by:SteelValley
[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
2 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 100 total points
ID: 35184404
0
 
LVL 11

Assisted Solution

by:Swindle
Swindle earned 150 total points
ID: 35184416
You can configure transaction log backups in either BackupExec or SQL Server.  If it is not necessary to restore the database to a point in time between your desired full backups, then it would be simpler to switch the recovery model to "simple".  To switch the recovery model from SQL Server Management Studio, simply right click on the database and choose properties.  Then click on the Options page.  You will see the "Recovery model" is set to either Full or Bulk-logged.  Change it to Simple and ok your way out of the properties.

If you need to have the ability to restore to a specific point in time between the normal full backups, this may require a little bit more thought and discussion to get the exact requirements.
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
A couple of months ago we ran into an issue that necessitated re-creating our Edge Subscriptions. However, when we attempted to execute the command: New-EdgeSubscription -filename C:\NewEdgeSub_01.xml we received an error indicating that the LDAP se…
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

632 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