Newbies knobshine Posted October 3, 2007 Newbies Share Posted October 3, 2007 Hi FM Forums, first post here... be gentle I'm using FM Server 8 on a XP Pro box and serving a data base (.fm7) from it. I need to get FM Server to close the database at a predetermined time and then open it again after an hour. Would I have to write 2x scripts for this (one to close the DB and one to open it again) and use the task schedular in FM Server to run them after one another or is there another way of doing this? I'm clueless as how to go about writing these scripts if that is the only way to do it. So any examples (or links to) will be much appreciated. Link to comment Share on other sites More sharing options...
Ender Posted October 3, 2007 Share Posted October 3, 2007 What is the purpose of closing the databases for an hour? For backups, you should use the built-in scheduled backups, then copy those backup sets for your archives. Link to comment Share on other sites More sharing options...
Newbies knobshine Posted October 4, 2007 Author Newbies Share Posted October 4, 2007 I need to close the database to replace it with a file of the same name. This is our test box, I need to replace the database it's using with a copy of the database from the live box. So the sequence needs to be: [color:green]Close DB on FM Server -> Replace DB with one of same name -> [color:green]Open DB for publishing on FM Server. The replacing of the file is done by remote by a data storage company. I just need to make sure the file is closed so they can work with it. I know it's a weird setup but my boss wants it this way. so... Link to comment Share on other sites More sharing options...
Conartist Posted December 12, 2007 Share Posted December 12, 2007 Did you figure out how to do this? I'm looking into an automated backup of the database files using SyncBack to backup directly to an ftp site. I'm thinking that to have the backup be as clean and as useful as possible the databases should be closed when the SyncBack backup is scheduled. I saw something related to using windows scheduled tasks to accomplish this but I'm just not entirely sure that the commands "FMServer STOP" and "FMServer START" are going to accomplish what I want. Any help is appreciated. Link to comment Share on other sites More sharing options...
AudioFreak Posted December 12, 2007 Share Posted December 12, 2007 Enders solution is the best way to do this. P.S. The boss isn't always right. Sometimes you just have to tell them this is the way it needs to be done. Link to comment Share on other sites More sharing options...
Scott Pon Posted August 25, 2008 Share Posted August 25, 2008 Did you ever find a solution to this? According to the Filemaker Server Admin, you can have the system run a "script" to close and open files. That is where I am headed. My situation is similar. but I want to run this close script so that I know the files are closed when I do a reboot. This should be done during the weekends. Link to comment Share on other sites More sharing options...
Vaughan Posted August 25, 2008 Share Posted August 25, 2008 I need to close the database to replace it with a file of the same name. This is our test box, I need to replace the database it's using with a copy of the database from the live box. FM Server 9 allows files to be closed, deleted, uploaded and opened (with permissions correctly set) using the remote administration tool from a remote computer. No need for scripts any more. :clap: Link to comment Share on other sites More sharing options...
Mikey79 Posted August 26, 2008 Share Posted August 26, 2008 What about having the FM server shutdown so a nice windows reboot can happen? The DB here is quite large (5gig or so) and from what I've seen the physical server can't be rebooted or some of the FM databases will become corrupted. Link to comment Share on other sites More sharing options...
Scott Pon Posted August 26, 2008 Share Posted August 26, 2008 FM Server 9 allows files to be closed, deleted, uploaded and opened (with permissions correctly set) using the remote administration tool from a remote computer. No need for scripts any more. You can do this remotely on Version 8 as well. I can't tell if he's trying to do this automatically or manually though. I thought it was automatic. Link to comment Share on other sites More sharing options...
Scott Pon Posted August 26, 2008 Share Posted August 26, 2008 What about having the FM server shutdown so a nice windows reboot can happen? The DB here is quite large (5gig or so) and from what I've seen the physical server can't be rebooted or some of the FM databases will become corrupted. My idea was to write a server-script that would close all the databases, then reboot the server. When the Server Reboots the database should open again. I would schedule this at like 2AM Link to comment Share on other sites More sharing options...
Scott Pon Posted August 26, 2008 Share Posted August 26, 2008 What about having the FM server shutdown so a nice windows reboot can happen? The DB here is quite large (5gig or so) and from what I've seen the physical server can't be rebooted or some of the FM databases will become corrupted. by the way you are right, Even though I asked my co-workers to close the databases, someone did leave it open, and some of the databases got corrupted ARG. fortunately FM was able to repair them. Link to comment Share on other sites More sharing options...
Vaughan Posted August 26, 2008 Share Posted August 26, 2008 You can do this remotely on Version 8 as well. No, the FMS 8 admin tool only allows the databases to be closed and opened. The ability to upload, remove and set permissions was introduced with FMS 9.0. Link to comment Share on other sites More sharing options...
Scott Pon Posted August 26, 2008 Share Posted August 26, 2008 No, the FMS 8 admin tool only allows the databases to be closed and opened. The ability to upload, remove and set permissions was introduced with FMS 9.0. Oh gotcha. thanks for clarification. Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted August 27, 2008 Share Posted August 27, 2008 When the Server Reboots the database should open again. This is [color:red]not a good idea or a best practice. The files should never be set to restart automatically. If there has been an inelegant shutdown, you need to examine the files for possible damage before continuing to use them. Steven Link to comment Share on other sites More sharing options...
Scott Pon Posted August 27, 2008 Share Posted August 27, 2008 This is [color:red]not a good idea or a best practice. The files should never be set to restart automatically. If there has been an inelegant shutdown, you need to examine the files for possible damage before continuing to use them. Steven Yes I agree. We're back to the original question... How do you automatically/schedule the server to close the files? Link to comment Share on other sites More sharing options...
Vaughan Posted August 28, 2008 Share Posted August 28, 2008 "How do you automatically/schedule the server to close the files? " What was the original problem? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5743 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now