8 Replies Latest reply on Jan 5, 2012 2:10 PM by Markus Schneider

    How to replace a corrupted database file in FMS?

    techdept

      Title

      How to replace a corrupted database file in FMS?

      Your post

      Our server on which FM Server 9 Advanced is installed shut down unexpectedly. This caused one of our hosted database files to close and not reopen, as seen in the Administration console. This file is a key component to one of our programs, and thus makes the whole program inoperable.

      I restored this file using the Restore command on FileMaker Pro11. The instructions in one of the FileMaker manuals cautions not to use this restored file going forward, but to copy the most recent changes to the original. How can this be done when the original file won't open?

      Then, I would need to replace the corrupted file with the restored version of it. What is the correct procedure to accomplish this?

      Thank you for your help!

        • 1. Re: How to replace a corrupted database file in FMS?
          philmodjunk

          Restore or Recover? Don't know of any Restore command Wink. It is not best practice to try to put a recovered copy of your file back into regular use. Almost always this is safe to do, but there's always a chance that the recover didn't produce a fully repaired copy of your damaged file.

          Instead, you should replace that file with an undamaged back up copy. You may need to open the back up copy and use Save a copy as... with the clone option to produce an empty copy of your file, then use Import Records to import the data from your recovered copy into your backup file.

          • 2. Re: How to replace a corrupted database file in FMS?
            techdept

            PhilModJunk,

            Yes, I did mean "Recover." Thank you for your thoroughly explained instructions. 

            Can you help with another FMS issue? We set a daily backup schedule in the Administrative Console. The backup is aborted and we receive this message:"'Data Base daily backup' aborted; no open databases to operate on." However, the status of all our databases is "Normal," not closed. Why are we getting this message?

             

             

            • 3. Re: How to replace a corrupted database file in FMS?
              Markus Schneider

              any chance that You copied the files into the FMS dirctory instead of using the 'upload command' from the console? With FMS 9 and newer, IMHO one should only use those commands to put files on the FMS.

              If not: Try to run the schedule using the admin console one more time and check for error mesages. If it still can't complete backups, try to stop/start the FMServer, maybe the Server itself (You did not mention the Server Hardware/system

               

              hth

               

              markus

              • 4. Re: How to replace a corrupted database file in FMS?
                techdept

                Markus,

                Yes, the database was uploaded using the console. The corrupted file most likely resulted from a power outage and server shut-down which happened last week.

                When I was in the console working on that file, I noticed that our latest backup is from April 2011. I updated all the settings in the backup scheduler to make sure they were correct. We still get the message that the backup was aborted because there were no open databases.

                Thank you,

                Nanette

                • 5. Re: How to replace a corrupted database file in FMS?
                  philmodjunk

                  Check your backup schedule details to make sure that it refers to the correct folder. You can group your hosted files into sub folders and use a schedule to back up all files within the specified sub folder. If it's referring to a folder that is the wrong one or which has since been deleted, you might get this error.

                  • 6. Re: How to replace a corrupted database file in FMS?
                    Markus Schneider

                    You could try to let a (new) schedule save the files to the default location - in addition to Phil's answer. Is there a reason that the schedule stopped working in april? Before aprli: Schedules were working?

                    btw: Disk-space... the disk is not full? (had this once...)

                     

                    markus

                    • 7. Re: How to replace a corrupted database file in FMS?
                      techdept

                      Markus,

                      The scheduler is set to save the files to the default backup location. There are backup files in this backup folder now, and they're all dated with the same April date. The "Last Run Status" on the Console scheduler, however, shows that that April backup was "aborted unexpectedly." After creating a new schedule yesterday, last night's backup status shows "Database unavailable." 

                      Thank you again for your comments and suggestions. Something is bound to click.Wink

                      Nanette

                       

                       

                       

                      • 8. Re: How to replace a corrupted database file in FMS?
                        Markus Schneider

                        You did a restart of the FMServer and/or the server machine? Permissions?

                        The backup-msg says 'unavailable' - but there are databases available when connecting from a client o the host? (server is up&running..)

                        Maybe reinstalling the FMS could help - after de-installing all of the server components. Not sure, but wasn't FMS 9 the one that left the apache config cluttered?

                        markus