SQL Queryfrom Suspect mode to normal

SQL Queryfrom Suspect mode to normal

 ***************************** Internal to Citixsys Support Team*********************************

Environment : 

iVend 6.6 7989 with SAPB1

Problem Statement :  

iVend database got Suspect Mode and there is need to move to Normal Mode.

Note : It should be discussed with Level 3 team first before using this one

SQL Queries : 


Option 1:

EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER

 Option 2:

--to return to multi-user mode:
ALTER DATABASE 'yourDBname';

SET MULTI_USER Use database_name
GO

ALTER DATABASE database_name SET SINGLE_USER

GO

DBCC CHECKDB('database_name', REPAIR_REBUILD)
GO

--to return to multi-user mode:
ALTER DATABASE <database-name> SET MULTI_USER


    • Related Articles

    • Change from Mixed Mode to Separate Store

      ------------------This article is for only internal use ------------------------ Product version: iVend 6.6 with SAPB1. Problem statement: A Store was created in mixed mode however it was required to be created as Separate Mode Store Proposed ...

    • POS - Transaction mode change event

      Introduction iVend Add-on Framework is used for writing Custom Business Logic independently by a programmer. iVend Addon allows to extend business logic either in Management Console or at the Terminal POS.The addon framework allows deployment of ...

    • POS - Transaction mode change event

      Introduction: iVend Add-on Framework is used for writing Custom Business Logic independently by a programmer. iVend Addon allows to extend business logic either in Management Console or at the Terminal POS. The addon framework allows deployment of ...

    • SAP Business One Gross Mode compatible with iVend

      Environment : Ivend reatail-6.6 Symptoms: SAP Business One Gross Mode compatible with iVend Problem Statement: Is SAP Business One Gross Mode compatible with iVend ? Resolution/Work Around: SAP Business One Gross Mode is not compatible with iVend , ...

    • Limit SQL SERVER memory consumption

      Version: Not the version-specific Query: Below query has been raised by one of the iVend user. I am experiencing in my HO server a lot of memory consumption when I checked it was the SQL SERVER, so I want to ask you if I can limit it, defining in SQL ...