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 |
|
Jamster69
Starting Member
4 Posts |
 Posted - 2012-09-06 : 10:45:06
|
Hi Guys Hello I'm new to this sql admin world. any how I think my log file is very large and growing. you probally get asked this question 1000 times ! Using SQL 2008 , created a maintenance plan.Recovery Model - FullFull backup - once dailyTrans log backup - every hourDatabase file - 7.5GBLog size - 52GB space used % 0.795 DBCC SQLPERF (LOGSPACE)Sql database disc 100Gb mdf size on this is 7.5 GB and ldf size is 52GBBackups are stored on a NAS the full database backup folder is 1.26 TB it has every full daily backup and log backup in it.So my question is my log file growing out of control and whats the best course of action pls :) |
|
|
Jamster69
Starting Member
4 Posts |
Posted - 2012-09-06 : 11:22:38
|
| If I am taken regular transaction log backups , 1 hour then the log file on the disc should not go over 52 gigs so i shouldn't run out of space. Running out of disc space is my main concern |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-09-06 : 11:44:13
|
Do you know? The log backup will not decrease the file size and new transaction log entries will use the reserved space inside the file.So it is possible the file size will stay at 52GB...
Too old to Rock'n'Roll too young to die. |
|
|
|
Jamster69
Starting Member
4 Posts |
Posted - 2012-09-06 : 12:30:25
|
| Thanks for your reply , i will monitor the file size as i cannot regain space back on the actual file size ? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-09-06 : 12:35:06
|
you can shrink the file but I would do that only if I'm sure that the use of 52GB was an exception otherwise the file will grow again and the shrinking was senseless.
Too old to Rock'n'Roll too young to die. |
|
|
|
Jamster69
Starting Member
4 Posts |
Posted - 2012-09-06 : 12:51:11
|
| Ok thank you very much. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Log file getting big and growing