You are viewing limited content. For full access, please sign in.

Search results for ""alter database""

Topics filtered:
  • Answered
    we are seeing this sequence: ALTER DATABASE [LFAudit] SET SINGLE_USER WITH ROLLBACK IMMEDIATE Setting database option SINGLE_USER to ON for database 'LFAudit' ALTER ... to ON for database 'LFAudit' ALTER DATABASE [LFAudit] SET AUTO_CLOSE OFF Setting database option AUTO_CLOSE to OFF for database 'LFAudit'   I turned off ......
    Profile image
  • to keep the logs small: ALTER DATABASE [yourDBname] SET RECOVERY SIMPLE DBCC SHRINKFILE("yourLogName") ALTER DATABASE [yourDBname] SET RECOVERY FULL ...
    Profile image
  • Answered
    Also, there is another command, alter database autoclose that runs a lot. We can also block the alter database commands. Would this cause an issue ......
    Profile image
  • Answered
    database recovery model to SIMPLE. ALTER DATABASE ScanRep1 SET RECOVERY SIMPLE;   -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (ScanRep1_log, 1);   -- Reset ......
    Profile image
  • Answered
    SQL Server Driver][SQL Server] ALTER DATABASE statement failed. This is with LF 10.2. Is this just something that cannot be enabled with Audit ......
    Profile image
  • the Laserfiche repository "Payroll". Function= ALTER DATABASE [laserfichepayroll] SET RECOVERY SIMPLE; Error=0x5BC; [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The operation cannot ......
    Profile image
  • Answered
    those that like to script: ALTER    DATABASE laserfiche_database SET RECOVERY SIMPLE DBCC    SHRINKFILE (laserfiche_database_Log, 1) The Full recovery model is typically used ......
    Profile image

Sign in to ask a question.