Re: [Veritas-bu] Bparchive status

2006-08-11 Thread Deiter Scott
Exactly.  Homer is now accepting suggestions!
 


Scott Deiter
717 633 3298

-Original Message-
From: bob944 [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 10, 2006 9:53 PM
To: veritas-bu@mailman.eng.auburn.edu; Deiter Scott
Subject: RE: [Veritas-bu] Bparchive status

> Windows 2000 and 2003 clients
> Netbackup 5.1 mp4
> Solaris master/media
> The bparchive is setup as a user backup 

bparchive is a user archive, not a user backup.  Details are important.

> and scripted in a dos.bat file.

>  PROBLEM:
> We have been forced to archive our sql tranasctions logs.
> We have attempted to use the bparchive against a temporary directory
> where we use robocopy to move the files from  source to this temporary
> directory.  The ugly thing that just happened is that on of the files
> was not completely there.  So a status 1 occurred.  None of the files
> where deleted.  So next time(daily) we must create another image of
> these files and hope for a status code 0. This consumes excessive tape
> and time. 2-7 gig per day.
> 
> How can we use set up an archive so that every successfully archived
> file is deleted at the end ?

"The ugly thing that just happened is that on of the files was not
completely there."  Huh?  Doesn't this make you do a "DOH!" Homer
Simpson headslap and realize your .bat contains a simplistic,
unfinished, ill-designed kludge masquerading as a business process?
Suggest it would be more productive to spend five minutes rethinking
your process than making it worse by adding file-at-a-time bparchive.


___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu


Re: [Veritas-bu] Bparchive status

2006-08-10 Thread Mansell, Richard
 
For our MS SQL databases we have included a final step in the hourly
transaction log dump which triggers a NetBackup job that performs a
differential backup to a disk staged area on the backup server. The
staged area then gets backed up to tape every three hours. 

The transaction logs left on the SQL server get purged after 3 days.
Being a Windows based server the purging script checks to make sure that
the archive bit has been reset before doing the deletion.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Deiter
Scott
Sent: Friday, 11 August 2006 6:08 am
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] Bparchive status

SETUP:
Windows 2000 and 2003 clients
Netbackup 5.1 mp4
Solaris master/media
The bparchive is setup as a user backup and scripted in a dos.bat file.



 PROBLEM:
We have been forced to archive our sql tranasctions logs.
We have attempted to use the bparchive against a temporary directory
where we use robocopy to move the files from  source to this temporary
directory.  The ugly thing that just happened is that on of the files
was not completely there.  So a status 1 occurred.  None of the files
where deleted.  So next time(daily) we must create another image of
these files and hope for a status code 0. This consumes excessive tape
and time. 2-7 gig per day.

How can we use set up an archive so that every successfully archived
file is deleted at the end ?



Scott Deiter

___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu


**
This electronic email and any files transmitted with it are intended 
solely for the use of the individual or entity to whom they are addressed. 

The views expressed in this message are those of the individual 
sender and may not necessarily reflect the views of the Christchurch
City Council.

If you are not the correct recipient of this email please advise the
sender and delete.

Christchurch City Council
http://www.ccc.govt.nz
**


___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu


Re: [Veritas-bu] Bparchive status

2006-08-10 Thread bob944
> Windows 2000 and 2003 clients
> Netbackup 5.1 mp4
> Solaris master/media
> The bparchive is setup as a user backup 

bparchive is a user archive, not a user backup.  Details are important.

> and scripted in a dos.bat file.

>  PROBLEM:
> We have been forced to archive our sql tranasctions logs.
> We have attempted to use the bparchive against a temporary directory
> where we use robocopy to move the files from  source to this temporary
> directory.  The ugly thing that just happened is that on of the files
> was not completely there.  So a status 1 occurred.  None of the files
> where deleted.  So next time(daily) we must create another image of
> these files and hope for a status code 0. This consumes excessive tape
> and time. 2-7 gig per day.
> 
> How can we use set up an archive so that every successfully archived
> file is deleted at the end ?

"The ugly thing that just happened is that on of the files was not
completely there."  Huh?  Doesn't this make you do a "DOH!" Homer
Simpson headslap and realize your .bat contains a simplistic,
unfinished, ill-designed kludge masquerading as a business process?
Suggest it would be more productive to spend five minutes rethinking
your process than making it worse by adding file-at-a-time bparchive.


___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu


[Veritas-bu] Bparchive status

2006-08-10 Thread Deiter Scott
SETUP:
Windows 2000 and 2003 clients
Netbackup 5.1 mp4
Solaris master/media
The bparchive is setup as a user backup and scripted in a dos.bat file.



 PROBLEM:
We have been forced to archive our sql tranasctions logs.
We have attempted to use the bparchive against a temporary directory
where we use robocopy to move the files from  source to this temporary
directory.  The ugly thing that just happened is that on of the files
was not completely there.  So a status 1 occurred.  None of the files
where deleted.  So next time(daily) we must create another image of
these files and hope for a status code 0. This consumes excessive tape
and time. 2-7 gig per day.

How can we use set up an archive so that every successfully archived
file is deleted at the end ?



Scott Deiter

___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu