(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) Missing .db file (Read 1357 times)
magicfish
Member
*
Offline



Posts: 47
Joined: Mar 18th, 2011
Missing .db file
Jun 5th, 2014 at 7:41pm
Print Post Print Post  
All of a sudden, I have lost a .db file. The .dat file is still there. The most recent backup is a week old. Is there any way to get the .db file back?
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Missing .db file
Reply #1 - Jun 6th, 2014 at 3:06pm
Print Post Print Post  
Your best bet would be to try and discover what made the .db file go away.

As to its recovery, there are two possibilities, either it was moved/renamed or it was deleted. If it was moved or renamed, dig in and find where it is now. If it was deleted an undelete utility may be able to recover it - especially if you have done very little with that computer since.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Missing .db file
Reply #2 - Jun 6th, 2014 at 3:33pm
Print Post Print Post  
Hello,

The DB and the DAT need to be of the same timeframe as they are a matched file pair, so unless you can find where the DB file ran off to, your option is to revert to your backup.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
magicfish
Member
*
Offline



Posts: 47
Joined: Mar 18th, 2011
Re: Missing .db file
Reply #3 - Jun 7th, 2014 at 11:57am
Print Post Print Post  
That's what I was afraid of. I was hoping that the db could be rebuilt somehow. I have no idea why or where it disappeared to. I guess Monday will be for re-entering a weeks worth of invoicing. Normally I wouldn't go that long without backing it up.
Thanks.
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Missing .db file
Reply #4 - Jun 7th, 2014 at 1:43pm
Print Post Print Post  
We have some facility here to extract the data from the .dat file. How complicated was your application? Is your latest .db using the exact same design as the .db file that you lost?
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
magicfish
Member
*
Offline



Posts: 47
Joined: Mar 18th, 2011
Re: Missing .db file
Reply #5 - Jun 9th, 2014 at 12:12pm
Print Post Print Post  
Mark,
The app isn't very complicated. We have the dat file, 7692 Kb, dated June 5, 3:18 pm. The latest db we have is dated May 29.
There has not been any design changes between them.
Glenn
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Missing .db file
Reply #6 - Jun 9th, 2014 at 1:10pm
Print Post Print Post  
Does the application have any sub-forms / sub-records?

I will talk to Ray and the powers-that-be about recovery cost. I'm in development, not support.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
magicfish
Member
*
Offline



Posts: 47
Joined: Mar 18th, 2011
Re: Missing .db file
Reply #7 - Jun 9th, 2014 at 1:35pm
Print Post Print Post  
There are no sub-forms or records.
Glenn
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Missing .db file
Reply #8 - Jun 9th, 2014 at 2:15pm
Print Post Print Post  
Ray says that "focused support" costs $50 per half hour.

There is no way of knowing exactly how long it will take to extract the data from your .dat file and get it into shape to re-import into your design, probably between four and eight hours. It may be more cost effective to go with your backup from a week ago.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
magicfish
Member
*
Offline



Posts: 47
Joined: Mar 18th, 2011
Re: Missing .db file
Reply #9 - Jun 9th, 2014 at 2:41pm
Print Post Print Post  
Thanks for your help, Mark. We're going to go with re-entering to the backup. I'm assured that "it won't take very long".  Roll Eyes
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Missing .db file
Reply #10 - Jun 9th, 2014 at 2:55pm
Print Post Print Post  
Until you discover what ate your file, make backups frequently.

Having the file simply disappear is very rare. We wrote the utility because people much more frequently accidentally overwrite the .db file with some other file - usually a word/excel document. That, or they overwrite it with an older .db file, thinking that that will revert their system to a previous state.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Missing .db file
Reply #11 - Jun 9th, 2014 at 7:12pm
Print Post Print Post  
magicfish wrote on Jun 7th, 2014 at 11:57am:
Normally I wouldn't go that long without backing it up.
Thanks.


MagicFish,

Are you familiar with the server Ini setting BACKUP ON INTERVAL?

It is an auto back-up command that has saved my A$$ more than once. You set the interval and it does the rest. I have found that with BACKUP ON INTERVAL and a batch file that moves the backups to an external hard drive at night I sleep much better. Just something to think about.
  
Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge