tallboy755 Posted December 23, 2002 Posted December 23, 2002 [color:"red"] As some of you have heard I had a loss in my family this week ... Her name was PC_Calendar_v2.fp5, and she died of "corruption" with 1500 plus records in her. I have had a hard time replacing her. How ever i do believe that I have found a fool proof way to prevent this from ever happening again. Here is the simple yet helpful script I am using as an "Exit Script" Save a Copy As (PC_Calendar_v2_BACKUP.fp5) As im sure all of you know filemaker doesn't really have a backup option. I just have this script set to run every time I close the database. [color:"blue"] I would like some feedback on what you think about it ... Let me know if there is anything that you can see that might make it not so "fool proof" [color:"purple"] Also please don't forget to rate me!! [color:"purple"] PC_Events.zip
kyle Posted December 24, 2002 Posted December 24, 2002 hi, tallboy ! what was the problem with your pc_calendar file ? what does error dialog box say ? you can't recover it or open due to file got demaged ? anyway , if your want to recover your records, send me a file. i will see what i can do for you. regards, kyle
Vaughan Posted December 24, 2002 Posted December 24, 2002 Remember, FileMaker is a development tool. It comes with nothing pre-built, the developer has to make everything happen. It has the *potential* to have auto-backups using the technique you have discovered -- there are probably more that other people have discovered. FMP also has a better backup system available if you team FMP up with FileMaker Server. Not really ecconomical wfor single users, but awesome for multi-user solutions.
tallboy755 Posted December 24, 2002 Author Posted December 24, 2002 The file just says that its corrupt ... I used the recover function and only salvaged about 300 of my 1500 records. I have attached the file for your viewing purposes. PC_Events.zip
kyle Posted December 25, 2002 Posted December 25, 2002 well, so you recovered some and lost some. then i guess that is it. yes, you have ti back up your files. now let's assume you back up your files by using filemaker back up script. then it will create a back up file in a same folder where your original file is. now what if your computer crashes ? you will lose your original file + your back up file same time. so safe back up is that you have to save your back up file at safe place either manually or automatically. if you use filemaker server back up process can be automated. for mac, you can use apple script. and for pc, we can automate this by using batch program in window 9.x. but i don't know it is still possible with window 2000 and NT AND XP ? SO I ASK IF I WANT TO BACK UP MY FILE INTO ZIP DRIVE OR TO SOME OTHER FOLDER IN A HARD DRIVE , IS IT POSSIBLE TO AUTOMATE THE BACK UP PROCESS IN WINDOW 2000 OR XP ? ANYONE ? regards, kyle
Vaughan Posted December 25, 2002 Posted December 25, 2002 The "Save a Copy As..." command can be set up to prompt the user for the path and name of the file. The use can then save to another disk. Of course, this requires a bit of self-assembly from the user.
SteveB Posted December 25, 2002 Posted December 25, 2002 You can automate the process on Windows platforms by using WinBatch. Goto www.wilsonware.com
kyle Posted December 25, 2002 Posted December 25, 2002 thanks, steve ! merry cristmas ! regards, kyle
tallboy755 Posted December 27, 2002 Author Posted December 27, 2002 to kyle: At this point I have the file Copying its self every time that its closed. It is copying to a server on my network. The "copied" files are then being backed up on tape every night. to vaughn: Under the "Save A Copy As" function you can specify a file. I have is set to overwrite the previous copy of the file upon exit... therefore eliminating all user intervention.
Recommended Posts
This topic is 8347 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