Re: Why use a backup agent?

From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 05/17/04 

Date: Mon, 17 May 2004 15:22:46 +0100

You don't need a Backup Agent to back up SQL Server. You can just use the
native backup to backup the files to disk and use the backup software to
backup those files to tape. Not all backup agents support log backups (or at
least not in the standard version), so that is a major limitation.

Native backup combined with a typical tape backup has worked fine for me. 

-- 
Jacco Schalkwijk
SQL Server MVP
"Steve Tyrol" <anonymous@discussions.microsoft.com> wrote in message
news:def901c43c18$465bf5d0$a401280a@phx.gbl...
> Can anyone give me a good reason why I would want to use
> the Backup Exec agent for SQL Server?  It seems to me
> (please correct me if I'm wrong) that you can get a high
> level of integrity in your database backups by using
> SQL's built in database and transaction log backup
> routines, in conjunction with a typical (non-SQL agent)
> tape backup of the server.
>
> Are there other considerations I'm missing?  Any
> structures that require an agent to backup?  I'd hate to
> spend the extra money on a backup agent if it's not
> necessary.
>
> Any help is greatly appreciated,
>
> Steve

Relevant Pages

  • Re: copy files while Backup Agent is running->error 46
    ... This is a common problem, caused purely by timing (i.e. backup up the ... Backup Agent, is to ensure that ALL files are open at the start of the ... While running PBA the datafiles are copied. ...
    (comp.databases.btrieve)
  • Re: Backup Agent
    ... Bill / Michael ... I think we will then use BUTIL and save the money for the backup agent. ... Create a batch file that runs immediately after your PVBACKUP -ON command that causes all of the "critical" Btrieve files to be opened. ... If we now start the Backup Agent, no files are set to continuous operation which is ok. ...
    (comp.databases.btrieve)
  • Re: Backup Agent
    ... Backup Agent suffers horribly from the absence of a "white list", or a way to force a given set of files open. ... Our application is using Pervasive Data Provider for .NET and database files are just opened if needed, meaning the database files are NOT constantly open. ... Now assuming the backup software starts backup for a large database file opening the file in read/write mode - now our application opens this file and Backup Agent tries to set it into continuous operation - this will fail because the file is already opened by the backup software. ...
    (comp.databases.btrieve)
  • Re: Event Error
    ... MSSQL$BKUPEXEC server they said I could un-select the backup agent for it ... Tim ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Brightstor Arcserve 9 Exchange Agent MAPI error
    ... I restarted the CA BrightStor Backup Agent RPC Server and thne I could ... I restart the following services; ...
    (microsoft.public.exchange2000.admin)