Jake: Created page with "== Database Offline or in Single-User Mode == The database may be put into ‘offline’ or single user mode due to a failed\interrupted windows update or unexpected shutdown. ..."

2017-03-09T05:40:52Z

Created page with "== Database Offline or in Single-User Mode == The database may be put into ‘offline’ or single user mode due to a failed\interrupted windows update or unexpected shutdown. ..."

New page

== Database Offline or in Single-User Mode ==

The database may be put into ‘offline’ or single user mode due to a failed\interrupted windows update or unexpected shutdown.

Perform the below steps to mark the database as online or to mark the database as multi-user.

== Bring EEPOS Database Online ==

=== Stop EEPOS Service ===

EEPOS and the POS Service need to be closed before performing the steps to bring the database online or set to multi-user.

1. Close EEPOS.

2. Open the Windows Services screen '''(Control Panel → Administrative Tools → Services)'''

3. Stop the '''EEPOS Service – MAGENTAPOS''' service.

=== Backup EEPOS Database Files ===

Perform a backup of the EEPOS Database files.

1. Browse to '''C:\Program Files\Microsoft SQL Server\MSSQL11.MAGENTAPOS\MSSQL\DATA'''

2. Make a copy of the '''EEPOSdat.mdf''' and '''EEPOSlog.ldf''' files.

'''Note:''' If a prompt appears saying that the files are currently in use you will need to temporarily stop the SQL Service.

3. Open the Windows Services screen '''(Control Panel → Administrative Tools → Services)'''

4. Stop the '''SQL Server (Magentapos)''' service.

5. Attempt to copy the '''EEPOSdat.mdf''' and '''EEPOSlog.ldf''' files again.

6. Start the '''SQL Server (Magentapos)''' service again.

=== Connect to Magentapos SQL Instance ===

Open SQL Management Studio on your EEE Server. Then connect to the tills local SQL Database over the network using the below details.

'''Server Name''' – Hostname\magentapos
'''Example:''' If hostname of till is Server40, then Server name should be Server40\magentapos

'''Authentication''' – SQL Server Authentication

'''Login''' – Magentasupport

'''Password''' – Please contact Magenta Support for the SQL Database Password.

[[File:SSMSLogin.jpg]]

=== Bringing Database Online ===
Once connected to the till’s Magentapos SQL Instance you will notice that the EEPOS database is shown as offline as per the screenshot below.

[[File:EEPOSOffline.jpg]]

Follow the below steps to bring the database back online.

1. Begin a new query by selecting '''New Query (CTRL+N)'''.

2. Copy the below SQL command into the new query window.

<pre>ALTER DATABASE EEPOS SET ONLINE</pre>

3. Select '''Execute (F5)''' to run the command.

4. Once this command has been run, select refresh in the Object Explorer (Red square below).
The EEPOS database should show as online.

[[File:EEPOSOnline.jpg]]

== Set Database Multi-User ==
If your database was diagnosed as being in Single-User mode, please follow the steps below.

=== Stop EEPOS Service ===

EEPOS and the POS Service need to be closed before performing the steps to bring the database online or set to multi-user.

1. Close EEPOS.

2. Open the Windows Services screen (Control Panel → Administrative Tools → Services)

3. Stop the EEPOS Service – MAGENTAPOS service.

=== Set Database as Multi-User ===

1. Connect to the SQL Instance using the above [http://theoracle.magentaretail.com.au/index.php?title=EEPOS:Database_Not_Online_and_Multi-User&action=submit#Connect_to_Magentapos_SQL_Instance Connect to Magentapos SQL Instance] instructions.

2. Begin a new query by selecting '''New Query (CTRL+N)'''.

3. Copy the below SQL command into the new query window.
<pre>
USE master
ALTER DATABASE EEPOS
SET MULTI_USER;
GO</pre>

4. Select '''Execute (F5)''' to run the command.

5. Once completed the results windows should show '''Command(s) completed successfully''' message as per the below screenshot.

[[File:CommandComplete.jpg]]

If the command fails to complete, please contact Magenta Support for additional assistance.

EEPOS:Database Not Online and Multi-User - Revision history

Jake: Created page with "== Database Offline or in Single-User Mode == The database may be put into ‘offline’ or single user mode due to a failed\interrupted windows update or unexpected shutdown. ..."