cancel
Showing results for 
Search instead for 
Did you mean: 

Backupexec 2012 Sql Issues

Dkromm
Level 3

I have a full back up for my Sql databases running nightly, I also have an incremental log backup set to run three times a week. Tuesday,Thursday saturday. My incremental backup has stopped working with the message saying it cannot run until the first full has ran. The fulls are running every night and completing with the exception that the log files will grow until they fill the drive. 

 

I believe the log back ups stopped working right around the time that my sql server gave me the backup wasnt down with the agent even though the agent is installed. The next day everything ran fine so didnt think much of it.

6 REPLIES 6

CraigV
Moderator
Moderator
Partner    VIP    Accredited

Hi,

 

Post the exact error messages as they will help troubleshoot.

Thanks!

Dkromm
Level 3

There is no error message for the incrmental it just wont run. The error on the full is just this over and over again for each database

V-79-40960-37914 - Database (DBNAME) is configured to maintain transaction logs. Transaction log backups are not bei...

 

then on the job setup is where i set the log wont run until the full has ran

pkh
Moderator
Moderator
   VIP    Certified

What are the exact error messages when you run the log backup?

Make sure that you are not running any other backups, like SQL Maintenance or VM backups between the full backup and the log backups.  These will disrupt the sequence.

Dkromm
Level 3

There is no error it just will not run, wont start nothing. Have tried rebuilding it everything. It will not run becuase it thinks there are no fulls becuase the fulls dont complete because the log error.

 

We have other VM backups that run but not on that server.

Colin_Weaver
Moderator
Moderator
Employee Accredited Certified

If you run VMware backups, then try to run a SQL LOG backup you must run a traditional agent based SQL backup (not a VMware backup ) first. It sounds like you are trying to mix up log backups with Vmware backups and not realizing you need to run a full SQL backup first.

 

BTW an Incremental VMware backup of a SQL server is NOT the same as a log backup (which is also traditional agent based)

Dkromm
Level 3

ok maybe we are gettung our signals crossed.

 

My sql servers backs up full every day with an agent my sql server is physical not virtual.  see the attached screen shots.

 

The vm backups that run in between the sql and the log have nothing to do with the sql server as my sql server is physical sorry I explained that wrong.