Re: Custom Script for Travan/miniQIC Tape Backups

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Henry Craven (IUnknown_at_Dot.Nyet)
Date: 09/25/04


Date: Sat, 25 Sep 2004 15:22:47 +1000

Thanks Owen. Much appreciated.
Look forward to giving it a Try and having a "play" with it.

-- 
Henry Craven {SBS-MVP}
    Melbourne Australia
"Owen Williams" <SpamProof@comcast.net> wrote in message
news:MPG.1bbe9dc8b00881dc989684@news.microsoft.com...
> FIRST, A MODEST REQUEST: I fully understand that Travan/miniQIC drives
> are not the best backup devices and are thought by many to deserve a
> place among the damned.  Notwithstanding, many of our clients have
them.
> What follows is my attempt to help those of you who ALREADY support
> Travan/miniQIC backup devices make the best of them.  I do NOT
recommend
> them if you are selecting a NEW backup device.  So please: No flames
by
> those who hate these devices.  Thanks!
>
> DISCLAIMER: What follows reflects my experiences.  It works for me but
> you should thoroughly test it to make sure it will work for you.
>
> MY STORY: One of my clients has a Seagate STT3401A (IDE Travan
> 20GB/40GB) streaming drive for SBS2003 backup.  Initially, backup
> success (backup + successful verify) with this drive was only 14% -
> totally unacceptable.  A call to the vendor (Dell) determined it was
> likely that [1] the drive was bad and/or [2] the drive microcode was
> corrupt or at least needed to be updated.  Vendor shipped new drive,
> which I installed, and also provided the latest microcode, which was
> updated without incident.
>
> Problem was, after the swap and microcode update, drive was identified
> as a miniQIC, not Travan.  Applying the patch from Microsoft Knowledge
> Base Article 831664 did NOT fix this.  Thus, the wizard-based SBS2003
> backup would not work at all.  Using a variety of resources -
magazines,
> this and other newsgroups, and lots of web searches - I built the
> following custom backup script which works with this drive as a
miniQIC
> and will probably work (with some modifications) with others.
>
> BOTTOM LINE: Backup success is now greater than 95%.  I have also run
> test restores, which worked fine.
>
> ADDITIONAL INFO:
> [1] The script includes an optional "trace" function which helps
> diagnose failures.
> [2] The Sleep command is available in pretty much any Windows Resource
> Kit.  Any comparable command which waits a specified number of seconds
> can be used instead.
> [3] I included some steps in the script to improve the probability of
> success with a Travan/miniQIC streaming drive, such as retensioning
the
> tape before performing the backup and ejecting it afterward.
> [4] The NTBackup command is explicitly specified in the script, not
> generated by SBS BackupRunner, so you have VERY granular control over
> all the options.
> [5] SBS2003 Server Management Backup thinks no backup is being run and
> will therefore NOT display backup results.  The script e-mails the
> summary backup log to anyone specified (see script for details) and
any
> number of logs can be retained for later review.  (Server Management
> Backup retains backup results as an XML file.  Perhaps someone with
more
> XML programming knowledge - and time on their hands - than I have will
> enhance the script to properly update that file.)
>
> BACKUP SCRIPT FOLLOWS - YOU PROBABLY *WILL* HAVE TO MODIFY IT A BIT!
> CAUTION: Longer command lines are wrapped by newsreader; examine
> carefully and unwrap them to make a working script.
>
> @Echo off
> ::
> :: Windows Small Business Server 2003 Full Backup to IDE Travan tape
> ::   drive script
> ::   Author: Owen Williams, ClearView Technology Consulting
> ::   As Of:  02 Sep 2004
> ::
> :: - - - - - - - - - -
> :: NOTE: This script should be scheduled using the Windows Scheduled
> :: Tasks applet (Start | All Programs | Accessories | System Tools |
> :: Scheduled Tasks).  Do NOT schedule SBS backups using the NTBackup
> :: scheduler.  The script should be run using an account which has
full
> :: Administrator privileges.  (Backup Operator privileges may work but
> :: have not been tested.)
> ::
> :: More information about backup batch files is available from the
> :: Microsoft reference article in Technet Q239892 "How to Schedule
> :: Unattended Backups Using a Stand-Alone Tape Library"
> :: - - - - - - - - - -
> Set Trace=Yes
> ::
> :: Set DateDay environment variable to the current date & day, e.g.,
> ::   20040526-Wed
> ::
> For /F "Tokens=1-4 Delims=/ " %%i In ('Date /T') Do Set
DateDay=%%l%%j%%
> k-%%i
> If %Trace%==Yes Echo Backup Trace for %DateDay%
>"%SBSProgramDir%\Backup
> \Trace.log"
> ::
> :: Use the Removable Storage Manager to refresh removable storage
media
> :: and wait 120 seconds to allow refresh to complete.  Low-cost IDE
> :: drives often do not notify removable storage that a tape has been
> :: loaded.  The refresh command queries the drive for any changes.
> ::
> :: NOTE: The Name of the device to be refreshed is aquired by typing:
> ::   RSM View /Tlibrary
> :: at a command line and selecting the correct device name.
> ::
> If %Trace%==Yes Echo RSM Refresh >>"%SBSProgramDir%\Backup\Trace.log"
> RSM Refresh /LF"Seagate STT3401A"
> Sleep 120
> ::
> :: Retension the tape, waiting until the retension completes before
> :: proceeding. This is an important step when using Travan and similar
> :: streaming drives to minimize media errors.  Freeware utility
> :: TapeUtil.exe is available from Bill Stewart's web site:
> :: http://home.comcast.net/~stewartb/misctools.html
> ::
> :: Usage: TapeUtil -r [drive#]
> ::        -r        Retension the media in the drive.
> ::        [drive#]  Number of the tape drive, numbered 0 through 9.
> :: (The utility has other functions; only retension is used in this
> :: script.)
> ::
> If %Trace%==Yes (
> TapeUtil -r 0 >>"%SBSProgramDir%\Backup\Trace.log"
> ) Else TapeUtil -r 0
> Echo TapeUtil Return Code: %ErrorLevel% >>"%SBSProgramDir%\Backup
> \Trace.log"
> ::
> :: Backup the folders/files specified in @[path to .BKS]  [Create the
> :: .BKS file using the SBS 2003 Backup Wizard.  Then, re-run the
Wizard
> :: and disable the automated SBS backup processing.  NOTE that you
will
> :: need to manually disable Exchange circular logging since the SBS
> :: Backup Configuration Wizard believes no backup is being performed.]
> :: - use the Normal (full backup with reset of archive bit) method
(/M)
> :: - backup from a volume shadow copy (/SNAP:on)
> :: - do not backup the Removable Storage Database (/RS:no)
> :: - backup to the miniQIC drive (/P "miniQIC") [Use "Travan" or other
> ::   media pool name if required on your system]
> :: - use hardware compression (/HC:on) if available
> :: - name the backup job (/J), tape (/N), and backup set (/D)
> ::   "%ComputerName%-%DateDay%"
> :: - verify the backup (/V:yes)
> :: - do not restrict access to the tape to members of Administrators
> ::   group (/R:no)
> :: - create a summary log file (/L:s)
> :: - use unmanaged backup method (/UM): whatever tape is in the drive
is
> ::   erased and used for the backup
> ::
> If %Trace%==Yes Echo NTBackup >>"%SBSProgramDir%\Backup\Trace.log"
> NTBackup backup "@%SBSProgramDir%\Backup\Small Business Backup
> Script.BKS" /M normal /SNAP:on /RS:no /P "miniQIC" /HC:on /J "%
> ComputerName%-%DateDay%" /N "%ComputerName%-%DateDay%" /D "%
> ComputerName%-%DateDay%" /V:yes /R:no /L:s /UM
> Echo NTBackup Return Code: %ErrorLevel% >>"%SBSProgramDir%\Backup
> \Trace.log"
> ::
> :: Use the Removable Storage Manager to eject the tape from the drive.
> :: This is an important line when using IDE-based tape drives.
NTBackup
> :: assumes ALL tape units eject their tapes.
> ::
> If %Trace%==Yes Echo RSM Eject >>"%SBSProgramDir%\Backup\Trace.log"
> RSM Eject /LF"Seagate STT3401A" /AStart
> Sleep 30
> ::
> :: Make a copy of the backup log in the SBS2003 folder used to save
> :: Backup Wizard logs, renaming the file and converting it from
Unicode
> :: to ANSI in the process.
> ::
> :: NTBackup creates log file names of the form "backup??.log" where ??
> :: is a number from 01 through 10.
> ::
> :: Dir backup*.log /B /O:D >LogFiles.txt - Sends a list of NTBackup
log
> ::   file names only (/B) sorted in ascending order by date/time
(/O:D)
> ::   to LogFiles.txt.  The last line of LogFiles.txt is thus the name
of
> ::   the newest log file: the one just created by the preceding
NTBackup
> ::   command.
> :: For /F %%f In (LogFiles.txt) Do Set NewestLog=%%f - Sends the lines
> ::   of LogFiles.txt (i.e., the log file names) to a Set command, one
by
> ::   one. The final Set command is the only one that matters: it sets
an
> ::   environment variable to the name of the newest log file.
> ::
> :: The Type command converts the log file from Unicode to ANSI for
> :: e-mail purposes.
> ::
> ChDir %UserProfile%\Local Settings\Application Data\Microsoft\Windows
NT
> \NTBackup\Data\
> Dir backup*.log /B /O:D >LogFiles.txt
> For /F %%f In (LogFiles.txt) Do Set NewestLog=%%f
> If %Trace%==Yes Echo Rename Log and Convert to ANSI >>"%SBSProgramDir%
> \Backup\Trace.log"
> Type %NewestLog% >"%SBSProgramDir%\Support\Backup Logs\SBSBackup%
> DateDay%.log"
> Del LogFiles.txt
> ::
> :: Create an e-mail message to the person(s) who monitor the backups.
> :: The file Backup_EMail_Header.txt must be a pure ANSI text file of
> :: RFC822-compliant addressing information:
> ::
> ::   To:[recipient's e-mail address(es), separated by commas]
> ::   From:[SBS administrator's e-mail address]
> ::   Subject:[Subject of your choice]
> ::
> ::   NTBackup Log Follows:
> ::
> :: NOTE: The blank line after Subject: is required for correct
> :: operation.
> ::
> :: File SBSBackup%DateDay%.log is appended to this file to create a
> :: complete e-mail message file.  The message file is copied to the
> :: Exchange mail Pickup folder where it will be automatically sent by
by
> :: the SMTP Connector.
> ::
> If %Trace%==Yes Echo Create e-mail file >>"%SBSProgramDir%\Backup
> \Trace.log"
> ChDir %SBSProgramDir%\Support\Backup Logs
> Copy Backup_EMail_Header.txt + SBSBackup%DateDay%.log
> Backup_EMail_Message.txt
> If %Trace%==Yes Echo Copy file to Pickup >>"%SBSProgramDir%\Backup
> \Trace.log"
> Copy Backup_EMail_Message.txt "C:\Program Files\Exchsrvr\Mailroot\vsi
1
> \Pickup"
> Del Backup_EMail_Message.txt
> ::
> :: Clean up the %SBSProgramDir%\Support\Backup Logs folder so it
> :: contains only the most recent 20 (4 weeks x 5 days/week) log files.
> ::
> :: Dir SBSBackup*.log /B /O:-N >LogFiles.txt - Sends a list of
SBSBackup
> ::   file names only (/B) sorted in descending order (/O:-N) to
> ::   LogFiles.txt
> :: For /F "Skip=20" %%f In (LogFiles.txt) Do Del %%f - Skips the first
> ::   20 lines of LogFiles.txt (i.e., skips the 20 newest SBSBackup
> ::   files), then deletes any older files.
> ::
> If %Trace%==Yes Echo Clean Up Backup Logs folder >>"%SBSProgramDir%
> \Backup\Trace.log"
> Dir SBSBackup*.log /B /O:-N >LogFiles.txt
> For /F "Skip=20" %%f In (LogFiles.txt) Do Del %%f
> Del LogFiles.txt
> ::
> :: End of Small Business Server 2003 Backup script.


Relevant Pages

  • Re: Offsite backup options
    ... you'd want to run it on a workstation so you don't hang the server, ... I like Exabyte VXA Drives for this. ... Until our backups start to exceed a single tape I just wanted to use ... the Built-In SBS Backup which works pretty good for our current needs. ...
    (microsoft.public.windows.server.sbs)
  • Re: Help Needed: Tape Backup Save Set
    ... >>explicit MOUNT helps me determine just where the problem is. ... so I just simply have backup mount the tape every time. ... Once I get a good set of TLZ drives, the jobs all tend to run fine. ...
    (comp.os.vms)
  • Re: NT Backup - WHAT A JOKE!
    ... I realize this forum may be dedicated to SBS but since ... REV USB drives and downloaded the latest iomega driver. ... Let that solution rest for self changer tape bank users who have ... possible to just follow the prompts and setup a backup scheduled to run ...
    (microsoft.public.windows.server.sbs)
  • Re: Back up failing
    ... MS is dropping tape support in SBS ... SBS Backup was starting...and the erroring out at 8:03pm every ... I use USB drives for archives....not daily backups. ... backup with the "Unable to detect tape drive or tape media. ...
    (microsoft.public.windows.server.sbs)
  • RE: Backup to USB Drives and 3rd Party Software
    ... last I checked 2.5” drives are ... I agree, always get the extended warranty with Backup Exec, if nothing else ... I disagree with your statemet "As we all know tape drives for small ... USB drives might cost less upfront, but I dont have problems with the drive ...
    (microsoft.public.windows.server.sbs)