=Condition / Cause=

This WIKI applies when ….

=Explanation of Process=

….

Notes:

• Existing users do / do not need to exit for these actions to be run.
• Always backup first! Running a SQL query is a powerful tool and a misplaced comma can result in data loss.

=Tier 2 Actions=

1. Have all users exit and close the SSLIP.
2. Check Computer Management and close any open files using the the ..\Cyrious$ folder or below.
3. Confirm you have the correct Data folder by looking at the modified date of the files in the data folder.
4. Backup the Database by
   • Right-clicking on the Data folder
   • Choosing Send To | Compressed File.
   • When complete, name the file “Data YYYY-MM-DD xx.zip”, as in “Data 2015-03-18 JB.zip” where “xx” are the technicians intials
   • Move the back up to the ..\Cyrious$\SMS\Tech Backups folder. Create the folder if it does not exist.
5. Locate the customer backup files and copy the Backup file to the ..\Cyrious$\SMS\Backups\ folder
6. Run Database Browser (DBBrowser.exe in the ..\Cyrious$\SMS\Utilities folder).
7. Click on the SQL tab, then click on Advanced in the middle row of tabs.
8. Modify and run the SQL below. You will need to adjust or confirm:
   • {Variable} - Description
   • {Variable} - Description
   • {Variable} - Description

code format="SQL"

set variables and run Define {Variable} value Define {Variable} value Define {Variable} value select * from “” ; </code> - Check and Confirm - Close DBBrowser - Talk to the Customer … =Task Information= * Last Updated: ___/2015 * Created By: * Verified By: * Applies to All Versions