Skip to content

Brakertech

tech problems: solved

 
  • Home
  • Bash Cheat Sheet
  • One Liners
    • active directory cheatsheet
    • bashrc tweaks for RHEL or CENTOS
    • Linux Command Line Shortcuts
  • Pentesting
    • Latest Exploits / Tools
    • Pentest-Service-Enumeration
    • Red Team Tools
  • RHCSA Quick-Notes
  • RHCSA Training Labs

truncate sql log

Steve Stonebraker
September 23, 2010

First off, You CANNOT REVERT this command, so be sure you want to truncate the log!
THE QUERY
Instructions: Just replace with your DB

BACKUP LOG  WITH TRUNCATE_ONLY 
DBCC SHRINKDATABASE( '', TRUNCATEONLY)

Share this:

Tags: log, mssql truncate log script, mssql truncate sql log, mssql truncating sql log, sql, truncate, truncate sql log

Post navigation

compare two files freeware
Howto: check database fragmentation sql server

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Categories

Active Directory (15) Admin (2) Apache (8) Applications (16) AWS (11) bash (18) c# (2) Defense (23) Discovery (2) Forensics (3) FreeBSD (35) games (2) Hacking (11) Hardware (11) Howto (20) IIS (23) Jenkins-Hudson (2) Kali (7) Linux (134) Mac (43) MSSQL (13) MYSQL (12) nginx (10) O/S (33) OSCP (1) Other (8) Pentesting (1) perl (4) php (2) Plugins (4) Podcast (1) powershell (1) powershell (3) Redhat Centos (78) Scripts (28) Security (28) Server Setup (32) Software (30) Teamsite (1) Tomcat (2) Tools (4) Ubuntu (49) Uncategorized (28) Windows (136) Wordpress (4)

Tags

active directory (4) admin (6) apache (10) aws (5) backup (4) bash (8) Bitnami (5) centos (4) cmd (3) database (3) dropbox (3) firewall (3) fix (7) freebsd (10) graylog (4) hacking (4) help (5) Howto (35) iis (7) IIS 6.0 (4) linux (13) Mac (6) mssql (4) MySQL (9) networking (3) ports (3) quality center (4) redhat (5) scripts (4) security (5) server 2003 (7) service (3) shell (5) sql (3) subversion (4) td (3) tutorial (3) ubuntu (11) unix (4) vmware (4) windows (26) windows server 2003 (3) windows vista (3) windows xp (4) wordpress (4)
Categories
Brakertech | Proudly Powered by WordPress
Theme by Grace Themes

Contact Us