Skip Navigation

Verify the database server

  1. Log in to 
    Microsoft SQL Server
     Management Studio as the NGAD user.
  2. Verify that the NGDeliverylog, NGDelivery, NGDeliveryAccount, and NGDiagnostics exist on the same database server.
  3. Check the database directory and verify that there are files for the database installed on the server.
  4. Open the ngdelivery database to verify that the Service Broker is enabled:
    1. Select from the dbo.AsyncSqlQuery table.
    2. In the query results, check the following values:
      • LastRunOn
         should be close to the current time.
      • LastRunOK
         should be ‘1’ 
        Service Broker view in the ngdelivery database
  5. If the service broker is not enabled, run the following query: 
    alter database RestoreDBName set enable_broker with rollback immediate
    .
If the Service Broker does not start, run the following script to restore the database: 
AtHocENS
\DeliveryServer\Installations\support\Utils\restore SQL.sql
.