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
Assinar:
Comentários (Atom)
Vimrc example
syntax on " modo visual/colorido ativo set showmode " apresenta o modo de utilizacao atual (comm...
Mais vistos
-
A few cmds to help with the DFS troubleshooting aspects, keep in mind all should be run from an elevated PowerShell Dfsdiag /TestDCs D...
-
Java Keytool Command These commands allow you to generate a new Java Keytool keystore file, create a CSR, and import certificates. A...
-
Find Users Who Have Never Logged On Use the following PowerShell Command; Get-ADUser -Filter { LastLogonDate -notlike "*" -and En...