Repairing Database

[frailer]

Seeing as there's quite a club developing here...   :cool:   Have just finished doing a little 'how to' for my Compadra here, as I'll be away for a few weeks.
If you have a power failure, and your UPS doesn't kick in properly, or it's after hours... you can have a situation where when you go to backup your database, (I do it on Fridays when I shut XMF Server down), you get a message 'Unable to backup, database corrupted'.. or words to that effect.
Here are the steps to repair it. I think this may change under upcoming versions on SQL. Currently XMF creates 2 files on each backup; a .dat (data) and a .idx (index).  If you have a meltdown, your local friendly Fujifilm tech will use your backup data to reconstruct your XMF site. Don't ask me for detail on how/why, I just follow orders.   :laugh:

https://www.dropbox.com/s/2rxxcwlez34qn2f/XMF_Database%20Repair%20routine_Rc.pdf

[Joe]

Good to know.