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 |
|
converge
Starting Member
7 Posts |
 Posted - 2004-10-03 : 00:58:49
|
| Hi, I have a database of 65Mg and the log file (.ldf) is 4.2 gig. The log file grow about 200 mg perweek. But when a of the log is made the backuped log file size is 300Mg. Is it me or something's wrong!!! Im new with Sql server administration so pls make your explaination detailed. Sim |
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-10-03 : 12:11:58
|
| Did u try scheduling automatic shrinking of the file ? |
 |
|
|
converge
Starting Member
7 Posts |
Posted - 2004-10-03 : 12:38:44
|
| Hi ruan4u thanks for your post,The answer is no I don't. When I select the database, then I choose Shrink database menu in the all task menu, here what I get:Space Allocated: 4289 MBSpace Free: 3783,18 MB (88%)The maximum free space in files after shrinking option is set to 0% And the Move page to the beginning of files before shrinking option is not checkedam I at the right place, If yes do I leave this to the default settings?T |
|
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2004-10-03 : 19:34:15
|
| You have your database set to Full logging which means that every transaction is placed on the end of your log file.You have a couple of options, you can put the db into simple mode but this would mean that your data can only be recovered to your last backup. The other option is to truncate the log after every backup. We have a 10gb database and the most our log gets to is 200mb because we back it up and truncate it. |
|
|
|
converge
Starting Member
7 Posts |
Posted - 2004-10-03 : 21:31:08
|
| Ok thanks a lot I'll try that. |
|
|
|
converge
Starting Member
7 Posts |
Posted - 2004-10-03 : 21:57:49
|
| I shrunk it and the size of the tlog drop to 530 MB, thx a lot. |
|
|
|
|
|
|
Transaction log file size growing rapidly