June 23, 2011 at 3:18 am
Hi,
Today I’ve noticed that drive with Logs for several databases is running out of free space. I’ve made some investigation and found that logs of 8 databases are being backuped on this drive. That backups take much of space and databases have no space to write their logs.
-- SQL 2008 RC in production server.
I have always issue with running out of FREE SPACE, which or what is best solution to avoid future error message.
Thnx
Kahn
June 23, 2011 at 3:27 am
Why have you posted this question in two places? You won't get an answer any quicker.
Original thread here:
http://www.sqlservercentral.com/Forums/Topic1130242-357-1.aspx
June 23, 2011 at 3:30 am
June 23, 2011 at 3:37 am
No reason to quick answer, weather i send this question to backup site or other place. thnx for remind.
June 23, 2011 at 5:31 am
Any other suggestioin regarding LOW SPACE.
THNX
June 23, 2011 at 6:17 am
Jayanth_Kurup (6/23/2011)
check the autogrowth setting for the log file in the db , make sure the db backups are compressed , enable database compression to reduce the size of the database.
All setting are ok, as you wrote.
Backup folder is taking more that 85% of drive for only 4 database logs. Log Shipping on that db.
thnx
June 23, 2011 at 7:07 am
i got this error mesg. 18210 and 14421 events in application log.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply