Truncating SQL Server Logs

Results 1 to 2 of 2

Thread: Truncating SQL Server Logs

  1. #1
    Rob Guest

    Default Truncating SQL Server Logs

    The database has 25 mb for the data and 13 for the trans log.<BR>We started getting "log file is full" errors. I truncated the log file however it is still the same size. And now I can not back the database up. We ordered mroe space and hopefully that helps.<BR><BR>Does anyone know?<BR><BR>Thanks,<BR><BR>Rob

  2. #2
    Join Date
    Dec 1969

    Default RE: Truncating SQL Server Logs

    Set "Auto shrink" option on. Then back up or truncate your log. This should free space up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts