Micros Simphony Database Backup

Backup Instructions

Datauser Credential Note: A typical datauser password would be Mr$ + Customer ID, but might be the enterprise number or our old phone number.  If unknown, use Single User Mode, described below.

It is prudent to perform a database backup prior to making major changes to the POS.

1. Create a file on the C: drive to receive the backup (dbBACKUP) if one does not already exist.
2. Kill all instances of servicehost.exe by opening the command prompt as administrator by typing in ‘cmd’ in the search field, right-clicking on the Command Prompt app, and selecting Run as administrator.
   
   
   
   
3. In the Command Prompt box, type:
   taskkill /im servicehost.exe /f /t
   This command kills all instances of servicehost.exe currently running. The output should look similar to:
   C:\Users\microsadmin>taskkill /im servicehost.exe /f /t
   SUCCESS: The process with PID 10572 (child process of PID 5448) has been terminated.
   SUCCESS: The process with PID 5448 (child process of PID 6340) has been terminated.
4. Restart the SQL server using net stop/net start commands:
   Net stop MSSQL$SQLEXPRESS
   Net start MSSQL$SQLEXPRESS
   The output should look similar to:
   C:\Users\microsadmin>Net stop MSSQL$SQLEXPRESS
   The SQL Server (SQLEXPRESS) service is stopping.
   The SQL Server (SQLEXPRESS) service was stopped successfully
   C:\Users\microsadmin>Net start MSSQL$SQLEXPRESS
   The SQL Server (SQLEXPRESS) service is starting.
   The SQL Server (SQLEXPRESS) service was started successfully.
5. Log on to the database by typing:
   sqlcmd –U datauser –P Mr$xxxxxxx –S localhost\sqlexpress
   Note: If the password is unknown, log on to the database by typing:
   sqlcmd -S.\sqlexpress
   This is known as Single User Mode.
6. The log in was successful if the output is a ‘1 >’. At that prompt, type in:
   BACKUP DATABASE Datastore TO DISK='C:\dbBACKUP\Datastore_backup.bak'

IF THE BACKUP FAILS:

Try using “ (double quotation mark) instead of ‘ (single quotation mark) to surround C:\dbBACKUP\Datastore_backup.bak.

A successful backup attempt’s output should look similar to:

C:\Users\microsadmin>Sqlcmd -U datauser -P Mr$xxxxxxx -S localhost\sqlexpress
1> backup database datastore to disk=" go
Processed 7432 pages for database 'datastore', file 'DataStore' on file 1.
Processed 3 pages for database 'datastore', file 'DataStore_log' on file 1.
BACKUP DATABASE successfully processed 7435 pages in 2.189 seconds (26.533 MB/sec).

Ensure a backup was made in the destination directory.