| |
| |
Best Practices: Creating and Storing Back-Ups of Older Versions of Data and OneSource
| Author: support staff Reference Number: AA-01188 Created: 2011-02-21 20:57 Last Updated: 2011-03-08 00:09 |
0 Rating/ Voters
|
 |
Data Backups
NOTE: ALWAYS
backup your data when you are updating to a new version, making changes
to the tables, or running/creating complicated queries. Any time you
feel your data may potentially be at risk, it is better to run a backup
than to pay the consequences later.
It is always a good idea to back up your data on a regular basis.
Depending on how much data you enter in a day/week/month, you may want
to run backups as often as twice a day. Daily backups ensure that if
anything happens to your data for any reason, you are at worst a day
behind if you have to restore from a backup. OneSource has tools in
place to make this an easy process.
The following can be done from any computer. It is recommended to at
least have this available on the server for quick backup. You only
have to create the script once, then you can use it whenever you want to
run a backup.
-
Make sure you set up your backup folders (see Best Practices: Folder and File Naming Conventions (A1193))
-
From within OneSource, select Tools, Admin Tools, Create Database Backup Script
-
There will now be a new icon on your desktop: 
-
Each time you double click that icon, a
message will come up "This process will make a disk-to-disk backup copy
of the specified file(s)". Press OK.
-
Your data file backup will be saved to your computer. The file will look like this: 20061206.XYZMusicData.MDB.40216.BAK,
where the first 8 digits are the date (YYYYMMDD), the next section is
the name of the file (YourCompanyFile.MDB) and the last section
distinguishes it as a backup file.
-
You can keep the file in this location, or move or copy it to another folder.
OneSource Backups
OneSource really only needs to be backed up if you are changing the
program itself (customizing or adding custom items) or updating to a new
version.
-
Make sure you set up your backup folders (see Best Practices: Folder and File Naming Conventions (A1193))
-
Locate your OneSource.mdb and OSMods.mde files (they will typically be located in C:\Program Files\OneSource\Data).
-
Highlight both files by pressing the Ctrl button and clicking once on the OneSource.mdb file and then once on the OSMods.mde file. Both should be highlighted.
-
Right mouse click on one of the files and select Copy.
-
Open your Backup File, right click your mouse and select New, Folder, and create a folder called Backup_YYMMDD (for example, Backup_061231). Open the new folder
-
Right click your mouse and select Paste. It should place your OneSource.mdb and OSMods.mde in the file. You now have a backup of your current files.
|
| |
|
