Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Backup Exec 2010 and Microsoft SQL

Posted on 2013-11-04
1
Medium Priority
?
691 Views
Last Modified: 2013-11-05
Hello,

Let me start by saying i do not know alot about databases and what should and shouldnt be backed up, thus brings me to my question. Backup exec backs up the server and the Microsoft SQL but when it completes i have the following exception:
V-79-40960-37914 - Database Prod_Vault 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 the simple recovery mode.

So should i change to simple recovery mode? If so what changes and what does it effect if anything?
or
Should i setup a backup to backup this log file as well? Will that take the exception away? Does this transaction log need to be backed up?

Backup Server
Windows Server 2003 x64
Backup Exec 2010

Server Backedup
Server 2008 x64
Microsoft SQL 2008

I would like to say thanks in advance for any help in this situation.

Rick
0
Comment
Question by:RickG2006
[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 3

Accepted Solution

by:
coreconcepts earned 1500 total points
ID: 39622250
Hi RickG,

       So if your database is set to FULL or BULK-LOGGED now then you must backup the transaction log regularly (everyone is different you may want it backed up every 5 minutes or every evening or on some different schedule).  FULL recovery mode is better - by all standards, though it does require a little more administrative overhead as you are discovering.  So, before changing the recovery mode to Simple, I would try to find out what your tolerance for data loss.  Your likely solution will be to create a log backup for the database in question.  I don't know much about Symantec's product, but you can find some help here most likely:

http://www.symantec.com/business/support/index?page=content&id=TECH126063

This is your specific error number in the Symantec support forum.

Hope that helps
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
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…

670 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