Our PA_Monitor database log file keeps filling up the drive on server overnight using 55GB of data. The log file remains fairly static throughout the day at around 990MB. Database on external SQL box running SQL 2003. We have other log files this server and we have discovered this is the database that is causing the issue. Where do I start looking to fix. Have checked the serverlog file and cant see anything obvious

asked 29 May '13, 11:26

francesbw's gravatar image

francesbw
111
accept rate: 0%


Hi,

Would you please run a report from your SQL server called Disk Usage by Table and send it to us at support@poweradmin.com.

Thanks
Quinn

link

answered 29 May '13, 11:45

Quinn's gravatar image

Quinn ♦♦
14.4k3925
accept rate: 35%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×33
×22
×17

Asked: 29 May '13, 11:26

Seen: 5,217 times

Last updated: 29 May '13, 11:45