run this command:
backup log databasename with no_log
backup log databasename with truncate_only
dbcc shrinkdatabase(databasename,1)
Subscribe to:
Post Comments (Atom)
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
No comments:
Post a Comment