Views:

To resolve the issue:

  1. Stop the Deep Security Manager service.
  2. Login the database server desktop and login the SQL server with SQL Server Management Studio.
  3. Open a new query and execute the following: ​​
     
    Make sure to replace the <DSM_database_name> in the command below with the actual DSM database name of the customer. For "dbcc shrinkfile", use the default file name when creating database. However, if the customer changed it, modify the value to the correct Logical Name to database files. To find the Logical Name, right-click the database and go to Properties > Files.
    use <DSM_database_name> 
    go
    alter database <DSM_database_name> set single_user with rollback immediate
    go
    dbcc checkdb ('<DSM_database_name>', REPAIR_FAST)
    go
    dbcc shrinkdatabase ('<DSM_database_name>', TRUNCATEONLY)
    go
    dbcc shrinkfile ('<DSM_database_name>', TRUNCATEONLY)
    go
    dbcc shrinkfile ('<DSM_database_name>_log', TRUNCATEONLY)
    go
    alter database <DSM_database_name> set recovery simple
    go
    alter database <DSM_database_name> set multi_user with rollback immediate
    go
  4. Start the Deep Security Manager service.