Manager SE Settings, Defaults, Database

Database backup files - Why are there two?

Database backup files - Why are there two?

Postby VirginiaO » Fri Jun 09, 2017 8:30 am

Rather than change the location each time in Manager when I do a backup, I'll just copy the file to a USB once in a while.
There are two files created each day in my C:\ProgramData\M1-SK\Backup folders. One in the morning, called for example, 2017-06-08M1SK.bak. Then one when I shut down the program, as that is my choice for daily backup, that goes to the subfolder Backup and is called ThursdayShopMgtDatabaseBackup.bak. These are nearly identical in file size.
I know that backing up straight to the USB will use the 'Thursday' file, but what's the difference between these two files? Why are there two per day?
Virginia
VirginiaO
Member
 
Posts: 20
Joined: Mon May 08, 2017 2:09 pm
Location: British Columbia

Re: Database backup files - Why are there two?

Postby Jeff @ Able Auto » Fri Jun 09, 2017 9:21 am

I believe the one you see in the morning is the auto back up that Mitchell runs overnight. Do you see a green or yellow check mark in the lower tray of the monitor? If so the odds are it's the M auto back up.
Jeff Fitzgerald owner
Able Auto Repair 772-462-0061
Treasure Coast of Florida
"there will be enough time to sleep when we're dead"
Jeff @ Able Auto
1500 Club Master Plus Contributor
1500 Club Master Plus Contributor
 
Posts: 1773
Joined: Thu Mar 01, 2007 12:19 pm
Location: Watch out for that cliff!!!

Re: Database backup files - Why are there two?

Postby Johnny5 » Fri Jun 09, 2017 3:24 pm

Manager without any intervention from the user, makes a backup in C:\ProgramData\M1-SK\Backup .

The file that is created when you exit manager and elect to make a backup is being stored in the same location. What you should do is set the manual backup drive letter to correspond with your thumb drive. That setting can be found in "Configuration" / "Special Maintenance" / "DataBase Backup". Then when you exit and backup, with the thumb drive in you don't need to copy files and worry if the copy was without problem. The reason there are two is simple: VERY CHEAP INSURANCE. YOU CAN NEVER HAVE TOO MANY CURRENT BACKUPS.

<I'll just copy the file to a USB once in a while. > Hopefully you aren't, but: Never backup once in a while. Stuff Happens. You should also call support immediately and have them make certain auto backup (a third copy) is operational.

Regards,

JD

Someday I may have the opportunity to tell you the story of a guy who went hunting deep in the woods with only 1 spare in the bed of his truck. :)
John Dwulet AKA: Johnny5
Sr. Product Marketing Manager - Mitchell1
Tuck in behind me, I'll show you where to crash. 8)
User avatar
Johnny5
System Guru / Moderator
System Guru / Moderator
 
Posts: 669
Joined: Wed May 26, 2004 2:03 pm
Location: Mitchell 1 John Dwulet, Sr. Product Marketing Manager

Re: Database backup files - Why are there two?

Postby VirginiaO » Mon Jun 12, 2017 11:23 am

Thanks, JD. I do backup every day, and take the USB file home with me with a weekly file. I didn't know a third location was an option. I'll definitely look into this.
Virginia
VirginiaO
Member
 
Posts: 20
Joined: Mon May 08, 2017 2:09 pm
Location: British Columbia

Re: Database backup files - Why are there two?

Postby Johnny5 » Mon Jun 12, 2017 11:52 am

:)
John Dwulet AKA: Johnny5
Sr. Product Marketing Manager - Mitchell1
Tuck in behind me, I'll show you where to crash. 8)
User avatar
Johnny5
System Guru / Moderator
System Guru / Moderator
 
Posts: 669
Joined: Wed May 26, 2004 2:03 pm
Location: Mitchell 1 John Dwulet, Sr. Product Marketing Manager

Re: Database backup files - Why are there two?

Postby sbcauto » Tue Jun 13, 2017 1:44 pm

I Have Two Thumb Drives, Mon-Wed-Fri And Tues-thur-Sat. I Back Up Only To The Thumb Drives Everyday A Take Drives Home With Me.
sbcauto
100 Club: Active Contributor
100 Club: Active Contributor
 
Posts: 139
Joined: Thu Feb 04, 2010 9:08 am

Return to Database / Settings

Who is online

Users browsing this forum: Bing [Bot] and 1 guest