Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Turn Off SQL Server Diff and Full Backup

Created: 14 Aug 2013 • Updated: 27 Aug 2013 | 3 comments
This issue has been solved. See solution.

I have inherited a system that uses Backup Exec 12.5 for backup.  One of the components had a SQL Server 2003 backend.  The data in the database is no longer used in production, only for archival queries.  We really have no need to run backups on the database, as we have a current copy of the database stored on and off location.

There are thee current jobs: Diff Daily (Diff and SQL), Full Weekly, and Full Monthly.

I am at a loss as to how I go about shutting off the SQL Backup.  I have seen posts saying that it should be as easy as removing from the selection, but I do not see anything associated with the database listed anywhere under the selections.

Thanks in advance,

Rick

Operating Systems:

Comments 3 CommentsJump to latest comment

lmosla's picture

Hello, if you go to View selection details ( the tab next to View by Resource) you should be able to see it listed there and you can select it and delete it.

Donald Eady's picture

Also, if the job doesnt emcompass a bunch of different servers it may be easier to just delete and recreate the job with the selections you would like it to be backing up... If you decide to do so i would suggest creating the replacement job fire placing the current on hold then delete the former job when comfortable. 

I hope this posting was helpful

  

RickRepsher's picture

Thanks to both for the replies.  It looks like I already did stop the SQL backups from happening.  I think the issue is more my lack of knowledge as to how things work. 

Our data gets backed up to a SAN, and then once a month to tape.  The LUN on the SAN has three folders, DIFF_SQL, FULL, SQL_LOGS.  Now that I look at it, I think that the daily differentials get written to the DIFF_SQL folder.  I was thinking that was just the SQL diff backup.  I am going to have to get some more HD Space!

Thanks again...

Rick

SOLUTION