SYMPTOM
How do I make a backup of my Yearli Desktop database file?
DESCRIPTION
Before a database can be manually backed up, the SQL Server instance
for Yearli must be temporarily stopped on the server
or
standalone machine. There are two ways to create the backup: using
the Yearli Backup App or manually creating the backup.
RESOLUTION
Procedure 1 (Using the
database backup application)
Note: If this is a network
installation, the following steps must be performed on the Yearli
Server computer.
- Close Yearli.
- Navigate to the Yearli Installation directory for the desired
year.*
- Open the Utilities folder.
- In the Utilities folder, right click the Yearli Desktop Backup
App and choose Run as Administrator.
- Click Next.
- Choose the year of the software you would like to backup.
- Click Browse to choose where the backup will be saved.
- Click Backup.
- Click Finish to close the wizard.
*The file directory will differ depending on the version of the program. The file directories associated with each version of the program are:
- WinFiler: C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler or WinFiler Server
- WinFiler Plus and Yearli 2014: C:\Program Files or Program Files (x86)\Greatland Corporation\WinFiler Plus or WinFiler Plus Server
- Yearli: C:\Program Files or Program Files (x86)\Greatland Corporation\Yearli or Yearli Server
Procedure 2 (Manual database
backup
instructions)
Note: If this is a network
installation, the following steps must be performed on the Yearli
Server computer.
- Close Yearli.
- Access the Microsoft SQL Server Configuration Manager. For
steps to do this see the How do I access SQL Server Configuration Manager? article.
- Click on SQL Server Services to display a list
of the currently running services.
- Right click SQL Server (YD2015_SS8E)* and click Stop.
- Minimize the SQL Server Configuration Manager.
- Navigate to the Yearli Installation directory
for
the desired year. (Installation
directory locations listed at the end of the document.)
- Copy the entire Data folder to a separate location.
- Open the minimized SQL Server
Configuration Manger.
- Restart the service by right-clicking the service and selecting
Start.
- Close the window.
*The
SQL Server instance will differ depending on the version of the
program. The SQL servers associated with each version of the program
are:
- WinFiler 2012 - 2013: WF_SS8E
- WinFiler Plus 2013 - 2014: WFP_SS8E
- Yearli 2014: WFP_SS8E
- Yearli 2015: WFP_SS8E or YD2015_SS8E
- Yearli 2016: WFP_SS8E or
YD2015_SS8E
APPLIES TO
- WinFiler 2012 - 2013
- WinFiler Plus 2013
- Yearli 2014 - 2017