Re: SQL Backup with Veritas BackupExec

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andras Jakus (AndrasJakus_at_discussions.microsoft.com)
Date: 08/04/04 

Date: Tue, 3 Aug 2004 23:15:03 -0700

HI

For better performance and usage:

Create backup devices for all db and backup type
Use separate device for each database.
Use separate device for backup tasks on database.

Eg:

SAMPLE_DATABASE

Create devices:
-SAMPLE_DATABASE_FULL
-SAMPLE_DATABASE_DIFF
-SAMPLE_DATABASE_LOG_1
-SAMPLE_DATABASE_LOG_2
-SAMPLE_DATABASE_LOG_3

-Sunday use SAMPLE_DATABASE_FULL for full db backup (with overwrite) and backup the file to tape.
-All other day use SAMPLE_DATABASE_DIFF for differential db backup (with overwrite) and backup the file to tape.
-And by day use log backup devices , also with overwrite

You can this method easy scripting. Also retsore methods or copy files towards off site server.

Notice: Perform veritas backup for devices prior overwrite!

Andras Jakus MCDBA

"Jonas Larsen" wrote:

> If you run SQL Server 7.0 or SQL2000 Start the Enterprise Manager - Expand
> Ms SQL Severs - "Your Server" - Management - Database Maintenance Plan.
> Create a new Maintenance Plan.
> This should take you through a Wizard where you get to select databases etc.
>
> With MS SQL Server 7.0 & 2000 there is Books Online which are really good
> for help in general.
>
> Regards
> Jonas
>
> "RAMTEK" <RAMTEK@discussions.microsoft.com> wrote in message
> news:A25CB290-F67D-481C-A5E3-B5C4DE537F03@microsoft.com...
> > We have been instructed by the software developers to NOT purchase the SQL
> module for Backup Exec, but instead set SQL to backup all transaction logs
> and both databases and put the backup file on the server prior to BackupExec
> running. Then when BackupExec run, it should only pick up the backup file.
> No one here knows anything about SQL, and the developers are not assiting
> us. Veritas successfully perfroms the backup of SQL in FULL, but fails in
> INCREMENTAL. How do I set SQL to backup trans logs and the 2 db's? I realize
> this is elementary for this group, but I am running out of places to turn.
> > Thanks!
> >
>
>
>

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
  • Re: Does NTBackup backup SQL Express?
    ... schedule backups of the SQL databases which were written to a backup ... models you would have to backup and flush things manually. ... if you load the backup set does the database appear to be ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)
  • Re: Does NTBackup backup SQL Express?
    ... as I know enough that the logs must be flushed during every full backup. ... and the SBS server I regularly use runs MySQL not SQL ... if you load the backup set does the database appear to be listed ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)
  • Re: URGENT: SQL 6.5 Server Crash
    ... > Are these database backup done by SQL Server? ... > Or file backups performed by some Windows backup software? ... were they performed while SQL Server was running? ...
    (microsoft.public.sqlserver.server)