Verify the database server
- Log in toMicrosoft SQL ServerManagement Studio as the NGAD user.
- Verify that the NGDeliverylog, NGDelivery, NGDeliveryAccount, and NGDiagnostics exist on the same database server.
- Check the database directory and verify that there are files for the database installed on the server.
- Open the ngdelivery database to verify that the Service Broker is enabled:
- Select from the dbo.AsyncSqlQuery table.
- In the query results, check the following values:
- LastRunOnshould be close to the current time.
- LastRunOKshould be ‘1’
- 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