Re: SBS2K3 Backup Wizard Script - how to find / alter



Hi Frank,

Thanks for the response. You must have missed my postscript in the original
post. I am reliably (alleged) informed by the company who installed the
Progress DB that it's not covered by VSS in a restorable manner. This
seemingly has something to with the way the DB is managed - it's all one big
DB file, a transaction log and a bunch of "image file things". I've worked
with Progress DBs before on Unix systems but then unix doesn't have any
wizards and you roll your own backups - so it's easy to stick the commands
in the appropriate places in the script.

I am currently doing as you suggest with a before script and after script in
the task scheduler but I'm just waiting for the day that some plonker does a
backup of his PC to the server. When this happens it will be possible for
the backup to extend beyond the scheduled start time for the service restart
task and I won't be certain that I have a usable backup of this DB. In fact
I may not even know there was a problem.

I reckon, but don't know for sure, that the SBS backup wizard must create a
script for the backup and then somehow schedule it. If I could find out
where the script is located (if it exists!) I could modify it accordlingly.
I could be just chasing a rainbow here but you never know! ;)

Sorry for the verbosity but it may help clarify.

Paul

"Frank McCallister SBS MVP" <anonymous> wrote in message
news:eqpW0zevFHA.3256@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Paul
>
> Are you certain that the VSS snapshot doesn't cover this like it does for
> Exch and SQL? If not create a two Batch files and set up a schedule in
> Task Scheuler to execute these prior to and at a sffe time when Backup is
> normally complete.
>
> --
> Frank McCallister SBS MVP
> COMPUMAC
> "Paul" <Paul@xxxxxxxxxxxxxxxxxxx> wrote in message
> news:Op9mJudvFHA.3984@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi,
>>
>> I have a Progress DB running on an SBS2K3 system which I would like to
>> include in the normal SBS scheduled backup. In order to do this I need to
>> shutdown the DB server to free the DB image file for backup. Essentially
>> this is a straightforward "net stop service" before the ntbackup begins
>> and a "net start service" after the ntbackup completes and before the
>> verify begins. I would like to inject these commands into the SBS backup
>> script but can't figure out how. Any links or advice appreciated.
>>
>> Thanks,
>>
>> Paul
>> P.S. I would rather not have two separate scripts which do this on a
>> scheduled basis.
>>
>
>


.



Relevant Pages

  • Re: batch file to delete files based on criteria
    ... >> I need to throw together a simple batch file to backup a file. ... >> schedule this via Task Scheduler to run every hour or so. ... > Create a snapshot backup when a file changes. ... >!Snapshot script from inside Windows Explorer. ...
    (microsoft.public.win2000.cmdprompt.admin)
  • Re: Scripting Windows 2008 System State Backup
    ... And then to not even have any documentation or examples of how to script it. ... part of our load we do a system state backup with Windows Backup. ... was quite easy you can schedule it and away you go. ...
    (microsoft.public.windows.server.general)
  • Re: Scheduling a script
    ... I do have a log file backup scheduled along with my regular backup. ... It can schedule jobs and run code. ... > Can I add though that this script is probably not a good idea. ...
    (comp.databases.ms-sqlserver)
  • Re: NTBACKUP log missing
    ... double clicking the batch script "backup.cmd" containing NTBACKUP ... Invoke "backup.cmd" to run by running a Backup Exec Job ... "backup??.log" file when you schedule the script to run using AT.EXE ...
    (microsoft.public.windows.server.general)
  • Feedback on backup script
    ... The one problem I have is that the script keeps stopping at lines 633,635 and or 637 with the error "Path Not Found" I have emailed the original author for help but haven't heard back yet. ... I was just wondering if the problem could be that the account running the script doesn't have correct permissions to a share/directory/file that it's trying to backup? ... ' always one less than the actual number of folders. ... ' Show the user free space info on all available disk drives ...
    (microsoft.public.scripting.vbscript)