Linux Unix MySQL MSSQL Windows Virtuozzo MRTG SNMP SMTP ASP.NET PHP IIS News IT Apache Parallels Plesk CommuniGate GNU GNOME KDE Solaris HP-UX FreeBSD RedHat Fedora CentOS Howto Database Replication Disaster Recovery High Availability High Performance Cluster Dynamic Cluster HTTP Proxy Squid Email Groupware Collaboration Instant Messenger Voice over IP VoIP IPSec Tunnel VPN Sniffer Software System Engineer Programmer Programming Certified SSL PKI Authentication script
Thursday, December 3, 2009
How to clear log and shrink database in MSSQL with transaction-sql
run this command:
backup log databasename with no_log backup log databasename with truncate_only dbcc shrinkdatabase(databasename,1)
No comments:
Post a Comment