Document Loader

 ProServe 2012 G2 - Service Management Software Solutions

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 ProServe 2012 and its SQL Databases.

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

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

Backup ProServe 2012 and its SQL Databases:

  • Make sure you're working on the Server or Main Computer that ProServe 2012 is installed on...
  • Shut down ProServe 2012 if it's running. (make sure no other users are running ProServe 2012)
  • 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 ProServe2012 folder along with the SQL Databases...
  • Using Windows Explorer locate and Right Click the ProServe2012 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) ProServeSystem
    2) ProServeCustomer
    3) ProServeInventory
    4) ProServeOrders
    5) ProServeGeneral
    6) GenLedger
    7) akSystem
  • ...
  • Now we are ready to Start back up the SQL Server Services and Attach the ProServe 2012 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 ProServe2012 folder on the external media and then Paste inside the ProServe2012 folder on your main drive.

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