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 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2008-01-28 : 22:09:16
|
| I have one log files which is almost filling up the disk so i added another files to different disk which has space of 150GB.So can i restrict the first log files so that it won't get filled up. Will the log go to next files. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-28 : 22:11:19
|
| How about you fix the reason why it is filling up so fast? How often do you run tlog backups?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-28 : 22:13:34
|
| The database is in simple recovery mode but i can't shrink the log file and the space was too less assigned so i have added disk space. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 22:18:33
|
| Yes you can set size limit for first log file. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-28 : 22:20:15
|
| Thanks rmaio.What if i don't restrict the first log file? will database be unaccessible? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 22:24:57
|
| No since there is second log file, but you'll run out disk space. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-28 : 22:27:30
|
| so rmaio i have log file for other database too in same drive in which log is filling up.what do you recommend to restrict or not to restrict the first log file? Please advise since you are expert. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 22:29:14
|
| You should restrict the first log file for that db. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-28 : 22:31:25
|
| THANKS |
|
|
|
|
|
|
restricting log space