Re: [Veritas-bu] Backing up SQL and Transaction logs?

Hello John

No particular reason. In fact 12 was incorrect, it was actually 5 hours - The backup window for the Full is 12 hours. So a mistype on my part.

What happens is this:

1) Full Backup runs

2) Logs captured at a later time once the full has been given time to complete.

I must admit, I have not seen the files truncate very well with NetBackup.

Simon

From: J.Keating AT tachi-s DOT com [mailto:J.Keating AT tachi-s DOT com]
Sent: Wednesday, October 14, 2009 1:17 PM
To: WEAVER, Simon (external)
Cc: VERITAS-BU AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Backing up SQL and Transaction logs?

Hello Simon,
Thanks for the reply and yes it does answer my question.
While reading through the admin guide I think I've come to the same conclusion.

Can I ask why you run the log backup's 12 hours after and not sooner? I would think that I would want to grab the logs ASAP after a "Full" in order to truncate and file away.
Thanks again.

Regards,
John Keating
Information Technology
Tachi-S Engineering U.S.A. Inc.

"WEAVER, Simon (external)" <simon.weaver AT astrium.eads DOT net>

10/14/2009 02:18 AM

To	<J.Keating AT tachi-s DOT com>, <VERITAS-BU AT mailman.eng.auburn DOT edu>
cc
Subject	RE: [Veritas-bu] Backing up SQL and Transaction logs?

John
Maybe I am doing it wrong, but this is what I do ...

1) Single .bch file called "SQL_Backup.bch" with the following:
OPERATION BACKUP
DATABASE $ALL
SQLHOST "<CLIENT>"
NBSERVER "<MASTER_NBU>"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
ENDOPER TRUE

This is created for a policy called "SQL_FULL_BACKUPS". This allows me to do a FULL Online SQL DB Backup of all DB's

Now for the Transaction logs, I do the following:
1) Single .bch file called "SQL_Backup_TXLogs.bch" with the following:
OPERATION BACKUP
DATABASE $ALL
SQLHOST "<Client>"
NBSERVER "<MASTER_NBU>"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
OBJECTTYPE TRXLOG
ENDOPER TRUE
This is then created for a second policy called "SQL_TX_LOGS" and runs AFTER the full SQL Backup has run (usually 12 hours after the SQL Full Backup Window starts).

I have had to restore SQL from the Full and Logs, and the DBA's have never complained.
I read through the SQL Admin guide to get most of this done.

Does this make sence, or answer your questions?
Simon

From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of J.Keating AT tachi-s DOT com
Sent: Tuesday, October 13, 2009 3:11 PM
To: VERITAS-BU AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Backing up SQL and Transaction logs?

Hello All,
I've been backing up several SQL servers for quite some time now and through re-creating a "disaster recovery" situation and reading through SAP section of the NetBackup SQL Admin guide I notice the section for backing up transaction logs.
After going through the SQL transaction log creation wizard, I verified the changes in that batch file to my original "Full" SQL batch file that I've been using.
The changes were these 2 lines:
BROWSECLIENT "CLIENT_NAME"
OBJECTTYPE TRXLOG

Am I correct to think that without these 2 lines in my batch file that a complete restore of the databases for SAP or otherwise would not happen?
Should I simply add these 2 lines to my original batch file?

Thanks for your help.

Regards,
John Keating
Information Technology
Tachi-S Engineering U.S.A. Inc.

This email (including any attachments) may contain confidential and/or privileged information or information otherwise protected from disclosure. If you are not the intended recipient, please notify the sender immediately, do not copy this message or any attachments and do not use it for any purpose or disclose its content to any person, but delete this message and any attachments from your system. Astrium disclaims any and all liability if this email transmission was virus corrupted, altered or falsified. -o- Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England

This email (including any attachments) may contain confidential
and/or privileged information or information otherwise protected
from disclosure. If you are not the intended recipient, please
notify the sender immediately, do not copy this message or any
attachments and do not use it for any purpose or disclose its
content to any person, but delete this message and any attachments
from your system. Astrium disclaims any and all liability if this
email transmission was virus corrupted, altered or falsified.
-o-
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office:
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu