March 8, 2010 at 8:11 am
I am kind of new to a small company as a web programmer. I am being asked to where many hats. The issue is disk space. We have about 20 (SQL2000) databases being backed up in full each night. The log files here just keep growing. (No in-house dba) Can I simply truncate and shrink these log files after a full backup for a short term solution. Other solution I am proposing is a separate disk drive for log files. But again when there is no database activity, can I simply truncate and shrink these log files after a full backup and ensure a I won't lose anything/ restore integrity?
March 8, 2010 at 8:39 am
You should not be truncating the log files. Either implement log backups (if you need point it time recovery) or switch to simple recovery.
Please read through this - Managing Transaction Logs[/url]
p.s. Please post SQL 2000 questions in the SQL 2000 forums in the future. There are lots of differences in maintenance between SQL 2000 and SQL 2008
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply