MS SQL Server - Veritas Backup Exec. 9.1 SQL Agent

Author

Veritas Backup Exec. 9.1 SQL Agent - Use of...

Jerry Spivey

2005-05-27, 1:23 pm

Hi,

Anyone currently using the Veritas Backup Exec. 9.1 SQL Agent for doing SQL
Server 2000 backups?

The environment I just inherited is using the Veritas software for daily
t-log backups and weekly full db backups. However the SQL Server is also
implementing backups (full, t-log) remotely to a share that gets backed up
weekly as well. I understand the backup strategies for backups in SQL
Server but I'm not sure what affect the Veritas SQL backups will have on the
SQL Server backups.

How are you using/combining the Veritas SQL backups with SQL Server backups?

Thanks

Jerry

Tibor Karaszi

2005-05-27, 1:23 pm

Don't mix tlog backups. Yo need to restore them in sequence. I suggest you do SQL backups, db and
tlog. Especially if you are familiar with that. If you feel for it, you can use veritas to do db
backups,. as that will not break the chain of log backups (assuming veritas does something strange
like truncating the log before the db backup).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
news:e7nGQBuYFHA.4036@tk2msftngp13.phx.gbl...
> Hi,
>
> Anyone currently using the Veritas Backup Exec. 9.1 SQL Agent for doing SQL Server 2000 backups?
>
> The environment I just inherited is using the Veritas software for daily t-log backups and weekly
> full db backups. However the SQL Server is also implementing backups (full, t-log) remotely to a
> share that gets backed up weekly as well. I understand the backup strategies for backups in SQL
> Server but I'm not sure what affect the Veritas SQL backups will have on the SQL Server backups.
>
> How are you using/combining the Veritas SQL backups with SQL Server backups?
>
> Thanks
>
> Jerry
>

Jerry Spivey

2005-05-27, 8:23 pm

Thanks Tibor...that was what I was concerned about. I think I'm going to
schedule full backups and t-log backups using Maint Plans to a remote share
and have the Veritas software backup the share contents to tape on a regular
basis.

"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:enO$LxuYFHA.3616@TK2MSFTNGP15.phx.gbl...
> Don't mix tlog backups. Yo need to restore them in sequence. I suggest you
> do SQL backups, db and tlog. Especially if you are familiar with that. If
> you feel for it, you can use veritas to do db backups,. as that will not
> break the chain of log backups (assuming veritas does something strange
> like truncating the log before the db backup).
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
> news:e7nGQBuYFHA.4036@tk2msftngp13.phx.gbl...
>
>

pdxJaxon

2005-05-27, 8:23 pm

Jerry,

you dont want to backup directly to a share.

backup locally and then copy to the share.

GAJ

Wayne Snyder

2005-05-29, 9:23 am

Don't mix backups... Either use Veritas, or standard SQL..

There is no problem backing up directly to the share - i prefer it..

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

"Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
news:e7nGQBuYFHA.4036@tk2msftngp13.phx.gbl...
> Hi,
>
> Anyone currently using the Veritas Backup Exec. 9.1 SQL Agent for doing
> SQL Server 2000 backups?
>
> The environment I just inherited is using the Veritas software for daily
> t-log backups and weekly full db backups. However the SQL Server is also
> implementing backups (full, t-log) remotely to a share that gets backed up
> weekly as well. I understand the backup strategies for backups in SQL
> Server but I'm not sure what affect the Veritas SQL backups will have on
> the SQL Server backups.
>
> How are you using/combining the Veritas SQL backups with SQL Server
> backups?
>
> Thanks
>
> Jerry
>

pdxJaxon

2005-05-29, 1:23 pm

you have not had issues doing large db backups over a lan ?

I certainly have.

GAJ

David Gugick

2005-05-31, 3:23 am

pdxJaxon wrote:
> you have not had issues doing large db backups over a lan ?
>
> I certainly have.
>
>
>
> GAJ

I agree that in most cases I would prefer to back locally. Backing up to
a share can certainly slow down the backup process. But for some
servers, this may not be an issue if off-hours activity is low. You also
find some customers have limited server drive / SAN space and backing up
to a share is the only option.

But for raw backup speed, local backups to a different array than the
data/log is the way to go.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com

Sponsored Links