AC (am**@desiboy.com) writes:
if you don't need the log anymore or the data inside it, this will
shrink it to 10MB.
DBCC SHRINKFILE (DBNAME_log, 10)
But shrinking the log to 10 MB is bad, unless this is just a database
you fool around in. If you don't backup the log as it should, the log
may grow overly large, but even if you run with simple recovery of at
least 100 MB is to recommend, maybe 1GB unless the database is really
small. With a small log file it will only auto-grow and that will slow
down operations, and can also lead to fragmentation of the file.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Links for SQL Server Books Online:
SQL 2008:
http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005:
http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx