RE: New to Rertospect and AppleScript question

[O'Donnell, Dan (NBC)]

Following was my strategy when I used FMP-S on a Mac.
(We're being forced to NT boxen now...)

Use the Retrospect Selector to _deselect_ the folder that FMP-S and the
database files themselves reside in.

Script Filemaker Pro Server to back up the individual databases to a
separate folder at some given time in the late night or early morning. This
backup takes less than a few seconds. 
Script FMP-S to shutdown the databases.

Script Retrospect to do its backup, including the folder that contains the
backed up database files (from FMP-S script), but excepting the deselected
folder.

Have another FMP-Server script open the databases (at a time after the Retro
backup has swept past).

In this way you have a good backup of closed database files, and you assure
that the files are really closed before the backup sweeps past.

By the way, doing several FMP-S backups of those files during the day takes
no time at all, and assures that you always have a copy of your database
files.

> 
> Another _very_ useful and important routine to run is to set 
> up a timed script
> in FileMaker that does a save as of the database(s).  This 
> ensures that there is an
> inert copy of the database that Retrospect can backup safely 
> and a emergency
> copy available to use if a crash renders the original unusable.
> 
> Cheers,
> 
> Erik Ableson
> 
> On Mon, Apr 17, 2000 at 03:39:25PM -0500, Jon Gardner wrote:
> > on 4/17/2000 1:41 PM, [EMAIL PROTECTED] at 
> [EMAIL PROTECTED] wrote:
> > 
> > >> I ran a backup on a test database and the backup ran 
> without any errors
> > >> (while FileMaker was still running).  I was then able to 
> restore the
> > >> database from tape and open it -- no problems, but 
> FileMaker Server was
> > >> never shutdown during the backup.
> > > 
> > > I just ran a similar test and found that the database was 
> backed up, but some
> > > indices had to be rebuilt.  Shutting down FileMaker 
> should give more reliable
> > > results.  I just posted a very similar question to yours, 
> before reading
> > > Friday's postings.  It would be very nice if the server 
> shutdown script could
> > > somehow be triggered by the Retrospect Client, but I 
> don't see a way to do
> > > that yet.
> > 
> > Just set up a script in FileMaker Pro Server to backup all 
> open databases at
> > a certain time, preferably just before the Retrospect 
> script is set to run.
> > It's all built-in. Ours does it every night at 8:00 or something.
> 

Because e-mail can be altered electronically,
the integrity of this communication cannot be guaranteed.


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:
Problems?:   [EMAIL PROTECTED]

Re: New to Rertospect and AppleScript question

[Church Initiative WebMaster]

Thank you, and every one, for your help!  Based on the responses I have
received, I have decided to create a backup of all of our FM databases using
the built-in FileMaker scripting tool (we were already doing this, it just
never occurred to me to use this in conjunction with Retrospect).
Retrospect will then back up these "inert" copies of the databases and
therefore I do not have to worry about automating the shutdown and startup
of FileMaker Server.

The first trial will be tonight, I will let you know what happens.

Thanks again and God bless,
Stiles Watson
Director of Information Services
The Church Initiative, Inc.
www.divorcecare.org
www.griefshare.org

- Original Message -
From: Erik Ableson <[EMAIL PROTECTED]>
To: retro-talk <[EMAIL PROTECTED]>
Sent: Monday, April 17, 2000 8:43 PM
Subject: Re: New to Rertospect and AppleScript question


> Another _very_ useful and important routine to run is to set up a timed
script
> in FileMaker that does a save as of the database(s).  This ensures that
there is an
> inert copy of the database that Retrospect can backup safely and a
emergency
> copy available to use if a crash renders the original unusable.
>
> Cheers,
>
> Erik Ableson
>
> On Mon, Apr 17, 2000 at 03:39:25PM -0500, Jon Gardner wrote:
> > on 4/17/2000 1:41 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
> >
> > >> I ran a backup on a test database and the backup ran without any
errors
> > >> (while FileMaker was still running).  I was then able to restore the
> > >> database from tape and open it -- no problems, but FileMaker Server
was
> > >> never shutdown during the backup.
> > >
> > > I just ran a similar test and found that the database was backed up,
but some
> > > indices had to be rebuilt.  Shutting down FileMaker should give more
reliable
> > > results.  I just posted a very similar question to yours, before
reading
> > > Friday's postings.  It would be very nice if the server shutdown
script could
> > > somehow be triggered by the Retrospect Client, but I don't see a way
to do
> > > that yet.
> >
> > Just set up a script in FileMaker Pro Server to backup all open
databases at
> > a certain time, preferably just before the Retrospect script is set to
run.
> > It's all built-in. Ours does it every night at 8:00 or something.
>
>
> --
> --
> To subscribe:[EMAIL PROTECTED]
> To unsubscribe:  [EMAIL PROTECTED]
> Archives:<http://list.working-dogs.com/lists/retro-talk/>
> Problems?:   [EMAIL PROTECTED]
>
>

_
NetZero - Defenders of the Free World
Click here for FREE Internet Access and Email
http://www.netzero.net/download/index.html


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:<http://list.working-dogs.com/lists/retro-talk/>
Problems?:   [EMAIL PROTECTED]

Re: New to Rertospect and AppleScript question

[Noah Eiger]

How is this different from just setting FMP Server's internal backup?

>Another _very_ useful and important routine to run is to set up a timed script
>in FileMaker that does a save as of the database(s).  This ensures 
>that there is an
>inert copy of the database that Retrospect can backup safely and a emergency
>copy available to use if a crash renders the original unusable.
>
>Cheers,
>
>Erik Ableson
>
>On Mon, Apr 17, 2000 at 03:39:25PM -0500, Jon Gardner wrote:
>>  on 4/17/2000 1:41 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
>>
>>  >> I ran a backup on a test database and the backup ran without any errors
>>  >> (while FileMaker was still running).  I was then able to restore the
>>  >> database from tape and open it -- no problems, but FileMaker Server was
>>  >> never shutdown during the backup.
>>  >
>>  > I just ran a similar test and found that the database was backed 
>>up, but some
>>  > indices had to be rebuilt.  Shutting down FileMaker should give 
>>more reliable
>>  > results.  I just posted a very similar question to yours, before reading
>>  > Friday's postings.  It would be very nice if the server shutdown 
>>script could
>>  > somehow be triggered by the Retrospect Client, but I don't see a way to do
>>  > that yet.
>>
>>  Just set up a script in FileMaker Pro Server to backup all open databases at
>>  a certain time, preferably just before the Retrospect script is set to run.
>>  It's all built-in. Ours does it every night at 8:00 or something.
>
>
>--
>--
>To subscribe:[EMAIL PROTECTED]
>To unsubscribe:  [EMAIL PROTECTED]
>Archives:
>Problems?:   [EMAIL PROTECTED]

-- 




Noah M. Eiger
Manager of Information Systems
Mother Jones Magazine / Foundation for National Progress
[EMAIL PROTECTED]
415-665-6637 x.204
http://www.motherjones.com




--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:
Problems?:   [EMAIL PROTECTED]

Re: New to Rertospect and AppleScript question

[Erik Ableson]

Another _very_ useful and important routine to run is to set up a timed script
in FileMaker that does a save as of the database(s).  This ensures that there is an
inert copy of the database that Retrospect can backup safely and a emergency
copy available to use if a crash renders the original unusable.

Cheers,

Erik Ableson

On Mon, Apr 17, 2000 at 03:39:25PM -0500, Jon Gardner wrote:
> on 4/17/2000 1:41 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
> 
> >> I ran a backup on a test database and the backup ran without any errors
> >> (while FileMaker was still running).  I was then able to restore the
> >> database from tape and open it -- no problems, but FileMaker Server was
> >> never shutdown during the backup.
> > 
> > I just ran a similar test and found that the database was backed up, but some
> > indices had to be rebuilt.  Shutting down FileMaker should give more reliable
> > results.  I just posted a very similar question to yours, before reading
> > Friday's postings.  It would be very nice if the server shutdown script could
> > somehow be triggered by the Retrospect Client, but I don't see a way to do
> > that yet.
> 
> Just set up a script in FileMaker Pro Server to backup all open databases at
> a certain time, preferably just before the Retrospect script is set to run.
> It's all built-in. Ours does it every night at 8:00 or something.


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:
Problems?:   [EMAIL PROTECTED]

Re: New to Rertospect and AppleScript question

[Jon Gardner]

on 4/17/2000 1:41 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:

>> I ran a backup on a test database and the backup ran without any errors
>> (while FileMaker was still running).  I was then able to restore the
>> database from tape and open it -- no problems, but FileMaker Server was
>> never shutdown during the backup.
> 
> I just ran a similar test and found that the database was backed up, but some
> indices had to be rebuilt.  Shutting down FileMaker should give more reliable
> results.  I just posted a very similar question to yours, before reading
> Friday's postings.  It would be very nice if the server shutdown script could
> somehow be triggered by the Retrospect Client, but I don't see a way to do
> that yet.

Just set up a script in FileMaker Pro Server to backup all open databases at
a certain time, preferably just before the Retrospect script is set to run.
It's all built-in. Ours does it every night at 8:00 or something.

<><
Jon L. Gardner '89, Computer Systems Manager 
Texas A&M University Dept. of Food Services 
Tel 979.458.1839 Fax 979.845.2157 ICQ 34792860
PGP public key available at 





--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:
Problems?:   [EMAIL PROTECTED]

Re: New to Rertospect and AppleScript question

[mark . maytum]

I know this doesn't directly answer the question (I haven't gotten the 
script to work either):

We just have our FileMaker server do a backup every two hours at 6am, 8am, 
10am, Noon, 2pm, 4pm & 6pm to a second HD on the same server.  It 
overwrites those every day.  Every night, this HD is backed up by another 
retrospect server (via the client) but the live databases are never backed 
up by retrospect.  This enables me to "roll back" to a good database 
version within 2 hours.  And I don't have to futz with applescript...

I have had a couple of our larger databases get hosed, but I've always 
been able to just copy the latest working version from the other hard 
disk.  I've never actually had to recover from a restrospect backup. 
Unless there's a catastrophic HD failure, I'll probably never have to use 
the retrospect backup of this server.

HTH,
Mark Maytum
Pompanoosuc Mills Corporation




[EMAIL PROTECTED]
Sent by: <[EMAIL PROTECTED]>
04/17/00 02:41 PM
Please respond to "retro-talk"

 
    To:     [EMAIL PROTECTED]
cc: 
    Subject:Re: New to Rertospect and AppleScript question


> I ran a backup on a test database and the backup ran without any errors
> (while FileMaker was still running).  I was then able to restore the
> database from tape and open it -- no problems, but FileMaker Server was
> never shutdown during the backup.

I just ran a similar test and found that the database was backed up, but 
some 
indices had to be rebuilt.  Shutting down FileMaker should give more 
reliable 
results.  I just posted a very similar question to yours, before reading 
Friday's postings.  It would be very nice if the server shutdown script 
could 
somehow be triggered by the Retrospect Client, but I don't see a way to do 

that yet.

Phil Geller
WorkingMacs








--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:<http://list.working-dogs.com/lists/retro-talk/>
Problems?:   [EMAIL PROTECTED]

Re: New to Rertospect and AppleScript question

[Workingmacs]

> I ran a backup on a test database and the backup ran without any errors
> (while FileMaker was still running).  I was then able to restore the
> database from tape and open it -- no problems, but FileMaker Server was
> never shutdown during the backup.

I just ran a similar test and found that the database was backed up, but some 
indices had to be rebuilt.  Shutting down FileMaker should give more reliable 
results.  I just posted a very similar question to yours, before reading 
Friday's postings.  It would be very nice if the server shutdown script could 
somehow be triggered by the Retrospect Client, but I don't see a way to do 
that yet.

Phil Geller
WorkingMacs


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:
Problems?:   [EMAIL PROTECTED]

Re: New to Rertospect and AppleScript question

[Luke Jaeger]

There's also the iDo script scheduler.

< http://www.sophisticated.com/software/sw_misc.html#ido_ss>

Matthew Tevenan wrote:
> 
> Stiles,
> 
> If you're somewhat familiar with AppleScript (and I'm not very, so don't ask
> me for programming tips), you can create what's called a "wait handler."
> This is basically running all the time, and waits until a certain time to do
> what you tell it to--for example quit FileMaker Pro Server. You could
> schedule it to happen before the time the script starts, then have it start
> it up again afterwards.
> 
> Pick up most any basic AppleScripting book for tips on how to do this.
> 
> Regards,
> 
> Matthew Tevenan
> Technical Support Specialist
> Dantz Development Corporation
> 925.253.3050
> [EMAIL PROTECTED]
> 
> > From: "Church Initiative WebMaster" <[EMAIL PROTECTED]>
> > Organization: Church Initiative
> > Reply-To: "retro-talk" <[EMAIL PROTECTED]>
> > Date: Fri, 14 Apr 2000 14:44:31 -0400
> > To: "retro-talk" <[EMAIL PROTECTED]>
> > Subject: Re: New to Rertospect and AppleScript question
> >
> > OK, I guess you WERE laughing since I received no response .
> > Regardless, I think I have figured out how to shut down FileMaker Server IF
> > it is running on the same machine as the Retrospect Server (just copy the
> > sample script from the AppleScript folder within the Retrospect folder to
> > the Retrospect Preferences folder), but what if FileMaker Server is on a
> > different server?
> >
> > Does anyone have any ideas on this?
> >
> > I ran a backup on a test database and the backup ran without any errors
> > (while FileMaker was still running).  I was then able to restore the
> > database from tape and open it -- no problems, but FileMaker Server was
> > never shutdown during the backup.
> >
> > Any help would be greatly appreciated!
> >
> > Stiles Watson
> 
> --
> --
> To subscribe:[EMAIL PROTECTED]
> To unsubscribe:  [EMAIL PROTECTED]
> Archives:<http://list.working-dogs.com/lists/retro-talk/>
> Problems?:   [EMAIL PROTECTED]

-- 


top of the world,

Luke Jaeger, Technology Coordinator
Disney Magazine Publishing
Northampton, Massachusetts
[EMAIL PROTECTED]

Any opinions expressed in this message are my own and may not represent
the opinions of Disney Publishing, etc etc etc.

*


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:<http://list.working-dogs.com/lists/retro-talk/>
Problems?:   [EMAIL PROTECTED]

Re: New to Rertospect and AppleScript question

[Luke Jaeger]

you can run Applescript from one mac to another. Turn on Program Linking
in the File Sharing control panel on the FileMaker server, then you can
have Retrospect call the script and the script call FileMaker and tell
it to quit.

Church Initiative WebMaster wrote:
> 
> OK, I guess you WERE laughing since I received no response .
> Regardless, I think I have figured out how to shut down FileMaker Server IF
> it is running on the same machine as the Retrospect Server (just copy the
> sample script from the AppleScript folder within the Retrospect folder to
> the Retrospect Preferences folder), but what if FileMaker Server is on a
> different server?
> 
> Does anyone have any ideas on this?
> 
> I ran a backup on a test database and the backup ran without any errors
> (while FileMaker was still running).  I was then able to restore the
> database from tape and open it -- no problems, but FileMaker Server was
> never shutdown during the backup.
> 
> Any help would be greatly appreciated!
> 
> Stiles Watson
> 
> - Original Message -
> From: Church Initiative WebMaster <[EMAIL PROTECTED]>
> To: retro-talk <[EMAIL PROTECTED]>
> Sent: Thursday, April 13, 2000 1:06 PM
> Subject: New to Rertospect and AppleScript question
> 
> > Our nonprofit company has just purchased Retrospect for Workgroups to
> backup
> > our Filemaker Pro databases, financial data, and the companies computers.
> I
> > know that in order to backup the database it must first be shut down and I
> > read about the suggested AppleScript in the manual that is supposed to do
> > this.  My questions are these, first, has anyone used these and do they
> work
> > as expected? Second, (now here is the really dumb part) not only am I new
> to
> > Retrospect, but also relatively new to the Mac world (I have worked with
> PCs
> > for many years), where do I put this AppleScript and how do I trigger it
> > from within Retrospect?
> >
> > Thanks for the help and thanks for not laughing!
> >
> > Stiles Watson
> >
> >
> > _
> > NetZero - Defenders of the Free World
> > Click here for FREE Internet Access and Email
> > http://www.netzero.net/download/index.html
> >
> >
> > --
> > --
> > To subscribe:[EMAIL PROTECTED]
> > To unsubscribe:  [EMAIL PROTECTED]
> > Archives:
> > Problems?:   [EMAIL PROTECTED]
> >
> >
> 
> _
> NetZero - Defenders of the Free World
> Click here for FREE Internet Access and Email
> http://www.netzero.net/download/index.html
> 
> --
> --
> To subscribe:[EMAIL PROTECTED]
> To unsubscribe:  [EMAIL PROTECTED]
> Archives:
> Problems?:   [EMAIL PROTECTED]

-- 


top of the world,

Luke Jaeger, Technology Coordinator
Disney Magazine Publishing
Northampton, Massachusetts
[EMAIL PROTECTED]

Any opinions expressed in this message are my own and may not represent
the opinions of Disney Publishing, etc etc etc.

*


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:
Problems?:   [EMAIL PROTECTED]

Re: New to Rertospect and AppleScript question

[Matthew Tevenan]

Stiles,

If you're somewhat familiar with AppleScript (and I'm not very, so don't ask
me for programming tips), you can create what's called a "wait handler."
This is basically running all the time, and waits until a certain time to do
what you tell it to--for example quit FileMaker Pro Server. You could
schedule it to happen before the time the script starts, then have it start
it up again afterwards.

Pick up most any basic AppleScripting book for tips on how to do this.

Regards,

Matthew Tevenan
Technical Support Specialist
Dantz Development Corporation
925.253.3050 
[EMAIL PROTECTED]

> From: "Church Initiative WebMaster" <[EMAIL PROTECTED]>
> Organization: Church Initiative
> Reply-To: "retro-talk" <[EMAIL PROTECTED]>
> Date: Fri, 14 Apr 2000 14:44:31 -0400
> To: "retro-talk" <[EMAIL PROTECTED]>
> Subject: Re: New to Rertospect and AppleScript question
> 
> OK, I guess you WERE laughing since I received no response .
> Regardless, I think I have figured out how to shut down FileMaker Server IF
> it is running on the same machine as the Retrospect Server (just copy the
> sample script from the AppleScript folder within the Retrospect folder to
> the Retrospect Preferences folder), but what if FileMaker Server is on a
> different server?
> 
> Does anyone have any ideas on this?
> 
> I ran a backup on a test database and the backup ran without any errors
> (while FileMaker was still running).  I was then able to restore the
> database from tape and open it -- no problems, but FileMaker Server was
> never shutdown during the backup.
> 
> Any help would be greatly appreciated!
> 
> Stiles Watson



--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:<http://list.working-dogs.com/lists/retro-talk/>
Problems?:   [EMAIL PROTECTED]

Re: New to Rertospect and AppleScript question

[Church Initiative WebMaster]

OK, I guess you WERE laughing since I received no response .
Regardless, I think I have figured out how to shut down FileMaker Server IF
it is running on the same machine as the Retrospect Server (just copy the
sample script from the AppleScript folder within the Retrospect folder to
the Retrospect Preferences folder), but what if FileMaker Server is on a
different server?

Does anyone have any ideas on this?

I ran a backup on a test database and the backup ran without any errors
(while FileMaker was still running).  I was then able to restore the
database from tape and open it -- no problems, but FileMaker Server was
never shutdown during the backup.

Any help would be greatly appreciated!

Stiles Watson

- Original Message -
From: Church Initiative WebMaster <[EMAIL PROTECTED]>
To: retro-talk <[EMAIL PROTECTED]>
Sent: Thursday, April 13, 2000 1:06 PM
Subject: New to Rertospect and AppleScript question


> Our nonprofit company has just purchased Retrospect for Workgroups to
backup
> our Filemaker Pro databases, financial data, and the companies computers.
I
> know that in order to backup the database it must first be shut down and I
> read about the suggested AppleScript in the manual that is supposed to do
> this.  My questions are these, first, has anyone used these and do they
work
> as expected? Second, (now here is the really dumb part) not only am I new
to
> Retrospect, but also relatively new to the Mac world (I have worked with
PCs
> for many years), where do I put this AppleScript and how do I trigger it
> from within Retrospect?
>
> Thanks for the help and thanks for not laughing!
>
> Stiles Watson
>
>
> _
> NetZero - Defenders of the Free World
> Click here for FREE Internet Access and Email
> http://www.netzero.net/download/index.html
>
>
> --
> --
> To subscribe:[EMAIL PROTECTED]
> To unsubscribe:  [EMAIL PROTECTED]
> Archives:
> Problems?:   [EMAIL PROTECTED]
>
>

_
NetZero - Defenders of the Free World
Click here for FREE Internet Access and Email
http://www.netzero.net/download/index.html


--
--
To subscribe:[EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:
Problems?:   [EMAIL PROTECTED]