MSSQL
Roles required for SQL user
The recommended login account for creating the database requires SQL authentication and it should have the following roles enabled: * dbcreator * Public * Sysadmin If you do not want to provide Sysadmin role to the user, db_creator and Public roles ...
The transaction log (Servicedesk_log.ldf) for database 'servicedesk' is full
There are two methods to fix this issue. Method 1 To fix this issue, we have to detach ServiceDesk database, after detaching we can delete the transaction log ( .LDF log) and attach the ServiceDesk database back. The important part in this process of ...
Move database from one machine to another
Following is the procedure to migrate your ServiceDesk Plus – MSP database from one MSSQL to another. Step 1: Stop ManageEngine ServiceDesk Plus – MSP service. Step 2: Take a backup of the existing data and configuration under MSSQL database. From ...
Steps to enable Read Committed Snapshot Isolation (RCSI)
Enabling Read Committed Snapshot Isolation in MS SQL server In MS SQL environments enabling 'Read committed Snapshot isolation (RCSI)' is the first step in handling application server performance and crash issues. What is RCSI? Since databases handle ...
SQL Master Key Password FAQs
How to create the master key password. The user with dbcreator permissions can follow these steps to create the master key password: Open MSSQL Server Management Studio, right-click the database and choose New Query In the workspace, run the ...