Solved

SQL online backup file

Posted on 2011-09-29
5
222 Views
Last Modified: 2012-05-12
I need to backup to tape everyday the .bak file that SQL online backup makes of all it's DBs. This .bak file changes names every time SQL does the online backup ofthose DBs. So the problem is that I'm pretty sure that Symantec BUEX wont be able to backup a file in a specific location that changes names everyday. Also, I cannot backup the entire folder the .bak file is in since there are also many differential backup files etc, I only need to backup to tape the .bak full.

Is there anyway that Symantec BUEX can go in and grab the .bak file everyday of the SQL online backup in these conditions?
0
Comment
Question by:tolinrome
[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
  • 2
5 Comments
 
LVL 30

Assisted Solution

by:Rich Weissler
Rich Weissler earned 100 total points
ID: 36818769
I'm not a Symantec BUEX person, so my tool of choice is going to be SQL.
The first option that comes to mind -- change the location where full backups are written.  There is a fair chance that the full backups are created in response to the maintenance plan.  You should be able to alter the maintenance plan so that either the differential backups or the full backups are written to a different directory from each other.  At that point, you should be able to backup the directory, just picking up the full backups.
(But to clarify, there are currently differential backups being created... and those differential backups also have .bak file extensions.  I'm assuming it's not transaction log backups (which often have .trn extensions) which are causing consternation.)
0
 
LVL 40

Expert Comment

by:lcohan
ID: 36893150
You should be able to backup the entire folder - INCREMENTAL so only new files created would be added to your tape. Please read details at link below about how to do that:

http://www.symantec.com/business/support/index?page=content&id=TECH10587
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 36893908
Oh... perhaps I misunderstood.  I was under the impression that there were differential backups generated by SQL which co-exist in the same directory as the full backups generated by SQL, and the user does not wish to ever backup those differential backup files.  I would assume by default there isn't a convenient method to differentiate between the full backups and differential backups.  Perhaps if there were a good way to strip the archive bit from the differential backup files without actually backing them up, the Incremental backup strategy would be inspired.
0
 
LVL 7

Author Comment

by:tolinrome
ID: 36903779
Hi Icohan,
That link just brings me to the main support website page.

Razmus - You are correct in your assumption, I only want to backup the latest .bsk full file from each directory.
0
 
LVL 40

Accepted Solution

by:
lcohan earned 400 total points
ID: 36905601
That link in my opinion shows you with screen shots how to d a Incremental backup:

<<......
Solution

What is a Incremental Backup?

An Incremental Backup is a way to back up only files which are new or have changed since the last Full or Incremental Backup. A Full Backup backs up all files on a system, and then sets the Archive Bit on all files that were backed up. An Incremental Backup backs up only files which do not have the Archive Bit set; it sets the Archive Bit on all files which it backs up.  More information regarding the function of the Archive Bit is available in the Archive Bit explanation below and the Related Documents section at the bottom of this TechNote.

To perform an Incremental Backup using the Backup Exec Main screen and not the Wizard, open Backup Exec and close the starter screen. Choose the backup job for the Full Backup if one exists, then click the radio button for New and Changed Files.....>>
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

688 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