Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Transaction Logs and Backups

Posted on 2011-03-21
2
Medium Priority
?
715 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
2 Comments
 
LVL 14

Accepted Solution

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

Assisted Solution

by:Swindle
Swindle earned 600 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
Steps to fix error: “Couldn’t mount the database that you specified. Specified database: HU-DB; Error code: An Active Manager operation fail”
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses

916 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