Backups And Large Logfiles

  • 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?

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply