With SQL 2000 always ran into the problem of the automatic log file size of the database, it defaults to the LDF file grows in size continuously until it reaches the maximum size set in the database, or worse, up to end of disk space.
This situation is created simply because the LDF file keeps track of all transactions, even when properly committed.
To resolve this problem, simply run the command: DBCC
BACKUP LOG [database name] WITH TRUNCATE_ONLY
simple, immediate, and above all, decisive.
via: merlinox.tumblr.com
0 comments:
Post a Comment