Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kpsreenath
Yak Posting Veteran
52 Posts |
 Posted - 2006-01-22 : 11:46:56
|
| Hi I am getting messages from BMC (monitoring tool) saying that a particular database log file is 99% full.I checked the database properties and found that the allocated space for the log file is around 250mb with automatic grow file by 10% and unrestricted file growth.Should i be concerned with this BMC message as long as there is enough space in the disk and the backup jobs are running fine.Thanks in advanceSreenath |
|
|
kpsreenath
Yak Posting Veteran
52 Posts |
Posted - 2006-01-22 : 11:48:05
|
| Just to add, How do i view with sql server how much percentage of log file is utilised? |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-01-22 : 13:08:03
|
| Try: DBCC SQLPERF(logspace)rockmoose |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-01-22 : 14:24:44
|
| It is also pretty important to schedule transaction log backups.-ec |
|
|
|
|
|
|
Log file 99% full