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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2008-05-20 : 12:25:36
|
| i want to create in sql 2005, maintainance plan that will shrink the LOG file.my current log file had came up to 110GB.under the OPTIONS its set to "FULL".how can i do this?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-20 : 12:29:53
|
| Take a log backup and try to shrink it.You should be taking transaction log backup frequently like every 20-30 mins to control log growth.If you can't shrink by any means,Take a full backup and put your database in simple recovery model and shrink log file.you don't need to create maintenance plan . |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2008-05-20 : 12:38:15
|
quote:
If you can't shrink by any means,Take a full backup and put your database in simple recovery model and shrink log file.
i know thatbut sytill i want automartic way to handle it.and wha t do u mean by : quote:
Take a log backup and try to shrink it.You should be taking transaction log backup frequently like every 20-30 mins to control log growth.
Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-20 : 12:44:01
|
| Transaction log backup will free up space by removing the inactive portion of the log and use DBCC shrinkfile to shrink log file. By taking log backup frequently will keep your log file in control. |
|
|
|
|
|
|
Maintainance Plan - shrink log