MS SQLServer clear log file


ALTER DATABASE <database_name>
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (<log_file_name>, 1)
GO
ALTER DATABASE <database_name>
SET RECOVERY FULL


-
Marcadores: ,

ESXi enable remote syslog

  esxcli system syslog config set --loghost=udp://10.20.0.27:514 esxcli network firewall ruleset set --ruleset-id=syslog --enabled=true  esx...

Mais vistos

  • Finding Stale User and Computer Accounts
    Find Users Who Have Never Logged On Use the following PowerShell Command; Get-ADUser -Filter { LastLogonDate -notlike "*" -and En...
  • JKS and Openssl commands
    Java Keytool Command These commands allow you to generate a new Java Keytool keystore file, create a CSR, and import certificates. A...
  • How to Configure WPAD through DNS
    First you have to configure a wpad site in your IIS Open the proxypac.pac file you have previously created and save as wpad.dat. Copy wpa...