think that log size has much to do with performance unless it starts to eat
other system resources. Log files should be on RAID 1 due to redundancy and
fast read performance (needed when backing logs up).
You can clean up your logs by performing transaction log backup (with remove
log entries option). Then you can shrink your DB (not recommended).
TK
[Tom Kitta]
-----Original Message-----
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: Monday, April 05, 2004 1:46 PM
To: CF-Talk
Subject: OT: SQL Server SLOW
Hey guys my transaction log is almost at 2 gigs. Will deleting this log
make SQL Server go faster? And if so, how do I go about deleting it safely
and starting a new one?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
