ProFrame 2015 - Wholesale Frame and Moulding Software Solutions

 

office (205) 467-7427
Springville, Alabama USA

Manually Backing Up Database Files...


This set of instructions assumes that you have some type of external media such as flash cards, thumb drives or external hard drives, and that you are familiar with using Windows Explorer to copy and paste files and folders.

 Follow instructions below to manually backup ProFrame 2015 and its SQL Databases.

Warning: it is not safe to copy or move any SQL Database while SQL Server is running...

Backup Overview:
  • Detach ProFrame 2015 SQL Databases from SQL Server...
  • Stop SQL Server...
  • Copy/Paste the ProFrame 2015 SQL Databases from and to some type of external media such as thumb drives or hard drives.
  • Start SQL Server...
  • Attach the ProFrame 2015 SQL Databases to SQL Server...

Backup ProFrame 2015 and its SQL Databases:

  • Make sure you're working on the Server or Main Computer that ProFrame 2015 is installed on...
  • Shut down ProFrame 2015 if it's running. (make sure no other users are running ProFrame 2015)
  • Click your Start Button, open All Programs and locate EasyBee Software...
  • Under EasyBee Software select SetConfig...

  • After the SetConFig program has started up... Select the Load button...
  • After the SQL Servers have loaded notice the Attach/Detach/Reattach Checkbox as shown below...

Detach...        Reattach...

  • This option has Three Positions: Checked - Attach, Blue - Detach and Off - Reattach...
  • We want to set it to Detach (Blue) then select the SQL Catalog button... (Do not select Configure even though it tells you to)
  • Exit this program after SQL Catalog has completed...
  • ...
  • Click the Start button, locate and start the SQL Server Configuration Manager...


You may wish to Pen this option to your Start Menu...


 

  • On the SQL Server Configuration Manager screen (shown above) make sure the SQL Server Services is highlighted on the left.
  • Now your SQL Server names may be different, most likely its SQLEXPRESS... and that's ok...
  • On the right side - make note of each Service that is Running so you can Start the ones that were running later...
  • Right Click each Running Service and select Stop (starting with the 1st one listed) as shown below...

  • After Stopping all SQL Server Services, leave this program running by selecting Minimize... you will need it later.
  • Now you're ready to backup the ProFrame 2015 folder along with the SQL Databases...
  • Using Windows Explorer locate and Right Click the ProFrame2015 folder then select Copy...
  • Using Windows Explorer locate and double click the external media such as thumb drives, flash cards etc... etc...
  • Locate and double click any special folder you may have created and right click then select Paste...
    Note: you may be prompted with a confirmation screen...
  • After paste has completed, verify that you have good copies of each SQL Database including associated log files.
    1) ProFrameSystem
    2) ProFrameCustomer
    3) ProFrameInventory
    4) ProFrameOrders
    5) ProFrameGeneral
    6) akSystem
  • ...
  • Now we are ready to Start back up the SQL Server Services and Attach the ProFrame 2015 databases...
  • Open the SQL Server Configuration Manager program from your Taskbar... (it should still be running)
  • Right Click each Stopped SQL Server Service that was Running before from previous step and select Start... as shown below.

 

  • After starting each Service... Close the SQL Server Configuration Manager program...
  • Now Startup the SetConFig program again located under Start - All Programs - EasyBee Software...

  • Select the Load button... (wait until all SQL Servers are loaded)
  • This Time we want to Attach, the Attach/Detach/Reattach option should be set to ON - Attach... (shown below)

  • Leave that option Checked ON and select the SQL Catalog button... (do not select Configure)
  • After this has completed... Close the SetConFig program...
  • Backup is complete...

To Restore: you would perform the same thing except you would Copy from inside the ProFrame2015 folder on the external media and then Paste inside the ProFrame2015 folder on your main drive.

Note: inside is the key word here... (don't try to restore the entire folder called ProFrame2015)