Re: logfiles grow non-stop in SQL2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

you can put the database into "Simple Recovery Mode" if you dont need the
T-logs.

If Simple Recovery is not an option, then backup logs regularly to avoid the
issue (Every hour, every 15 minutes, whatever)


cheers

Greg Jackson
PDX, Oregon


.

Relevant Pages

  • Re: What is prev1.edb and why is it 15 GB?
    ... > Whereas the database was new and everything was available> to rebuild the database we moved all the database and log> files into a temporary location. ... Had to manually mount the mail store so it> created a new database. ... Only> problem we have is when starting Outlook on the clients> we get a message stating Exchange is currently in> recovery mode. ... The choices are connect, work offline and> cancel. ...
    (microsoft.public.windows.server.sbs)
  • Re: ntbackup & MS SQL 2k SP3 on Server 2003
    ... > dual Xeon Dell server that came preinstalled with Server 2003. ... Further tests showed that the error only appears when backing up from a volume on which there a database files of a database in Full Recovery mode. ... So it is not a problem if SQL Server is installed and running - you simply cannot backup databases in Full Recovery mode using a file backup. ...
    (NT-Bugtraq)
  • Re: Strange SQL Server Timeout Problem
    ... I've set the database to use SIMPLE recovery mode. ... huge transaction log associated with the database. ... first suggestion, so I'll check back to see whether the logfile shrinks ...
    (microsoft.public.sqlserver.server)
  • Re: Logging
    ... First thing to consider is your backup strategies. ... If you don't perform transaction log backups, ... the database to simple recovery mode. ... Read more about this in Books Online, simple recovery mode. ...
    (microsoft.public.sqlserver.server)
  • Re: Trans. log backup wont execute
    ... You can't do log backup on a database in simple recovery mode. ... >>> in the job history or in the SQL Server Logs. ...
    (microsoft.public.sqlserver.server)