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
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 |
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|