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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 log files are getting huge

Author  Topic 

jung1975
Aged Yak Warrior

503 Posts
Posted - 2006-08-17 : 16:03:53
Ok...here is my log files status..everything is 2 ( active)..how can I shrink this log file.. I would like to continue to do a fullback up along with a log backup... it seems like the size of log files are getting bigger and bigger .. what would be the best way to matntain the log file size?
FileId FileSize StartOffset FSeqNo Status Parity CreateLSN
2 253952 8192 0 0 128 0
2 253952 262144 786 2 128 0
2 253952 516096 0 0 64 0
2 278528 770048 0 0 64 0
2 262144 1048576 0 0 64 7000000043000013
2 262144 1310720 0 0 64 8000000046100008
2 262144 1572864 0 0 64 9000000047700004
2 262144 1835008 0 0 64 11000000001600001
2 262144 2097152 0 0 64 11000000044700005
2 262144 2359296 0 0 64 12000000039500021
2 262144 2621440 0 0 64 13000000042900017
2 327680 2883584 0 0 64 14000000046200010
2 327680 3211264 0 0 64 16000000013100015
2 393216 3538944 0 0 128 17000000013100021
2 393216 3932160 0 0 128 18000000024700020
2 458752 4325376 0 0 128 19000000024700015
2 253952 4784128 0 0 128 20000000047800014
2 270336 5038080 0 0 128 20000000047800014
2 253952 5308416 0 0 128 21000000046200009
2 270336 5562368 0 0 128 21000000046200009
2 253952 5832704 0 0 64 23000000041200021
2 335872 6086656 0 0 128 23000000041200021
2 253952 6422528 0 0 128 25000000047700021
2 401408 6676480 0 0 128 25000000047700021
2 253952 7077888 0 0 128 27000000041200017
2 466944 7331840 0 0 128 27000000041200017
2 253952 7798784 0 0 128 29000000039500019
2 253952 8052736 0 0 128 29000000039500019
2 278528 8306688 0 0 128 29000000039500019
2 253952 8585216 0 0 128 32000000036200015
2 253952 8839168 0 0 128 32000000036200015
2 344064 9093120 0 0 128 32000000036200015
2 253952 9437184 0 0 128 35000000036200018
2 253952 9691136 0 0 128 35000000036200018
2 475136 9945088 0 0 128 35000000036200018
2 253952 10420224 0 0 128 38000000036200016
2 253952 10674176 0 0 128 38000000036200016
2 253952 10928128 0 0 128 38000000036200016
2 286720 11182080 0 0 128 38000000036200016
2 262144 11468800 0 0 64 42000000036300015
2 262144 11730944 0 0 64 42000000036300015
2 262144 11993088 0 0 64 42000000036300015
2 393216 12255232 0 0 128 42000000036300015
2 327680 12648448 0 0 128 179000000001600260
2 327680 12976128 0 0 128 179000000001600260
2 327680 13303808 0 0 128 179000000001600260
2 327680 13631488 0 0 128 179000000001600260
2 327680 13959168 0 0 128 215000000049600130
2 327680 14286848 0 0 128 215000000049600130
2 327680 14614528 0 0 128 215000000049600130
2 458752 14942208 0 0 128 215000000049600130
2 393216 15400960 0 0 128 286000000025600249
2 393216 15794176 0 0 128 286000000025600249
2 393216 16187392 0 0 128 286000000025600249
2 393216 16580608 0 0 128 286000000025600249
2 393216 16973824 0 0 64 481000000013600227
2 393216 17367040 0 0 64 481000000013600227
2 393216 17760256 0 0 64 481000000013600227
2 524288 18153472 0 0 64 481000000013600227
2 458752 18677760 0 0 64 483000000049600231
2 458752 19136512 0 0 64 483000000049600231
2 458752 19595264 0 0 64 483000000049600231
2 524288 20054016 0 0 64 483000000049600231
2 524288 20578304 0 0 64 486000000037600174
2 524288 21102592 0 0 64 486000000037600174
2 524288 21626880 0 0 64 486000000037600174
2 524288 22151168 0 0 64 486000000037600174
2 524288 22675456 0 0 64 489000000049600097
2 524288 23199744 0 0 64 489000000049600097
2 524288 23724032 0 0 64 489000000049600097
2 720896 24248320 0 0 64 489000000049600097
2 589824 24969216 0 0 64 492000000023200001
2 589824 25559040 0 0 64 492000000023200001
2 589824 26148864 0 0 64 492000000023200001
2 720896 26738688 0 0 64 492000000023200001
2 655360 27459584 0 0 64 495000000013600111
2 655360 28114944 0 0 64 495000000013600111
2 655360 28770304 0 0 64 495000000013600111
2 786432 29425664 0 0 64 495000000013600111
2 720896 30212096 0 0 64 498000000013600217
2 720896 30932992 0 0 64 498000000013600217
2 720896 31653888 0 0 64 498000000013600217
2 851968 32374784 0 0 64 498000000013600217
2 786432 33226752 0 0 64 511000000037600228
2 786432 34013184 0 0 64 511000000037600228
2 786432 34799616 0 0 64 511000000037600228
2 983040 35586048 0 0 64 511000000037600228
2 917504 36569088 0 0 64 513000000061600239
2 917504 37486592 0 0 64 513000000061600239
2 917504 38404096 0 0 64 513000000061600239
2 917504 39321600 0 0 64 513000000061600239
2 983040 40239104 0 0 64 515000000085600001
2 983040 41222144 0 0 64 515000000085600001
2 983040 42205184 0 0 64 515000000085600001
2 1114112 43188224 0 0 64 515000000085600001
2 1114112 44302336 0 0 64 517000000133600222
2 1114112 45416448 0 0 64 517000000133600222
2 1114112 46530560 0 0 64 517000000133600222
2 1114112 47644672 0 0 64 517000000133600222
2 1179648 48758784 0 0 64 532000000001600232
2 1179648 49938432 0 0 64 532000000001600232
2 1179648 51118080 0 0 64 532000000001600232
2 1376256 52297728 0 0 64 532000000001600232
2 1310720 53673984 0 0 64 534000000049600041
2 1310720 54984704 0 0 64 534000000049600041
2 1310720 56295424 0 0 64 534000000049600041
2 1441792 57606144 0 0 64 534000000049600041
2 1441792 59047936 0 0 64 540000000136800001
2 1441792 60489728 0 0 64 540000000136800001
2 1441792 61931520 0 0 64 540000000136800001
2 1572864 63373312 0 0 64 540000000136800001
2 1572864 64946176 0 0 64 546000000073600001
2 1572864 66519040 0 0 64 546000000073600001
2 1572864 68091904 0 0 64 546000000073600001
2 1769472 69664768 0 0 64 546000000073600001
2 1769472 71434240 0 0 64 548000000109600074
2 1769472 73203712 0 0 64 548000000109600074
2 1769472 74973184 0 0 64 548000000109600074
2 1835008 76742656 0 0 64 548000000109600074
2 1966080 78577664 0 0 64 552000000253600231
2 1966080 80543744 0 0 64 552000000253600231
2 1966080 82509824 0 0 64 552000000253600231
2 1966080 84475904 0 0 64 552000000253600231
2 2162688 86441984 0 0 64 554000000217600158
2 2162688 88604672 0 0 64 554000000217600158
2 2162688 90767360 0 0 64 554000000217600158
2 2162688 92930048 0 0 64 554000000217600158
2 2359296 95092736 0 0 64 556000000208800001
2 2359296 97452032 0 0 64 556000000208800001
2 2359296 99811328 0 0 64 556000000208800001
2 2424832 102170624 0 0 64 556000000208800001
2 2621440 104595456 0 0 64 558000000241600201
2 2621440 107216896 0 0 64 558000000241600201
2 2621440 109838336 0 0 64 558000000241600201
2 2621440 112459776 0 0 64 558000000241600201
2 2883584 115081216 0 0 64 560000000289600231
2 2883584 117964800 0 0 64 560000000289600231
2 2883584 120848384 0 0 64 560000000289600231
2 2883584 123731968 0 0 64 560000000289600231
2 3145728 126615552 0 0 64 563000000013600187
2 3145728 129761280 0 0 64 563000000013600187
2 3145728 132907008 0 0 64 563000000013600187
2 3276800 136052736 0 0 64 563000000013600187
2 3473408 139329536 0 0 64 575000000270400001
2 3473408 142802944 0 0 64 575000000270400001
2 3473408 146276352 0 0 64 575000000270400001
2 3538944 149749760 0 0 64 575000000270400001
2 3801088 153288704 0 0 64 577000000486900001
2 3801088 157089792 0 0 64 577000000486900001
2 3801088 160890880 0 0 64 577000000486900001
2 3932160 164691968 0 0 64 577000000486900001
2 4194304 168624128 0 0 64 589000000722200001
2 4194304 172818432 0 0 64 589000000722200001
2 4194304 177012736 0 0 64 589000000722200001
2 4325376 181207040 0 0 64 589000000722200001
2 4587520 185532416 0 0 64 592000000181600025
2 4587520 190119936 0 0 64 592000000181600025
2 4587520 194707456 0 0 64 592000000181600025
2 4784128 199294976 0 0 64 592000000181600025
2 5111808 204079104 0 0 64 596000000229600133
2 5111808 209190912 0 0 64 596000000229600133
2 5111808 214302720 0 0 64 596000000229600133
2 5111808 219414528 0 0 64 596000000229600133
2 5570560 224526336 0 0 64 599000000805600280
2 5570560 230096896 0 0 64 599000000805600280
2 5570560 235667456 0 0 64 599000000805600280
2 5767168 241238016 0 0 64 599000000805600280
2 6160384 247005184 0 0 64 604000000865600111
2 6160384 253165568 0 0 64 604000000865600111
2 6160384 259325952 0 0 64 604000000865600111
2 6225920 265486336 0 0 64 604000000865600111
2 6750208 271712256 0 0 64 608000000002400201
2 6750208 278462464 0 0 64 608000000002400201
2 6750208 285212672 0 0 64 608000000002400201
2 6946816 291962880 0 0 64 608000000002400201
2 7471104 298909696 0 0 64 611000001237600169
2 7471104 306380800 0 0 64 611000001237600169
2 7471104 313851904 0 0 64 611000001237600169
2 7471104 321323008 0 0 64 611000001237600169
2 8192000 328794112 0 0 64 613000000961600224
2 8192000 336986112 0 0 64 613000000961600224
2 8192000 345178112 0 0 64 613000000961600224
2 8323072 353370112 0 0 64 613000000961600224
2 9043968 361693184 0 0 64 615000000757600229
2 9043968 370737152 0 0 64 615000000757600229
2 9043968 379781120 0 0 64 615000000757600229
2 9043968 388825088 0 0 64 615000000757600229
2 9895936 397869056 0 0 64 624000000625600233
2 9895936 407764992 0 0 64 624000000625600233
2 9895936 417660928 0 0 64 624000000625600233
2 10092544 427556864 0 0 64 624000000625600233
2 10944512 437649408 0 0 64 628000000097600186
2 10944512 448593920 0 0 64 628000000097600186
2 10944512 459538432 0 0 64 628000000097600186
2 10944512 470482944 0 0 64 628000000097600186
2 11993088 481427456 0 0 64 632000000889600083
2 11993088 493420544 0 0 64 632000000889600083
2 11993088 505413632 0 0 64 632000000889600083
2 12189696 517406720 0 0 64 632000000889600083
2 13238272 529596416 0 0 64 634000001411100071
2 13238272 542834688 0 0 64 634000001411100071
2 13238272 556072960 0 0 64 634000001411100071
2 13238272 569311232 0 0 64 634000001411100071
2 14548992 582549504 0 0 64 641000002539800444
2 14548992 597098496 0 0 64 641000002539800444
2 14548992 611647488 0 0 64 641000002539800444
2 14614528 626196480 0 0 64 641000002539800444
2 15990784 640811008 0 0 64 645000001925100018
2 15990784 656801792 0 0 64 645000001925100018
2 15990784 672792576 0 0 64 645000001925100018
2 16121856 688783360 0 0 64 645000001925100018
2 8781824 704905216 0 0 64 649000000157600202
2 8781824 713687040 0 0 64 649000000157600202
2 8781824 722468864 0 0 64 649000000157600202
2 8781824 731250688 0 0 64 649000000157600202
2 8781824 740032512 0 0 64 649000000157600202
2 8781824 748814336 0 0 64 649000000157600202
2 8781824 757596160 0 0 64 649000000157600202
2 9043968 766377984 0 0 64 649000000157600202
2 9699328 775421952 0 0 64 657000001724900004
2 9699328 785121280 0 0 64 657000001724900004
2 9699328 794820608 0 0 64 657000001724900004
2 9699328 804519936 0 0 64 657000001724900004
2 9699328 814219264 0 0 64 657000001724900004
2 9699328 823918592 0 0 64 657000001724900004
2 9699328 833617920 0 0 64 657000001724900004
2 9699328 843317248 0 0 64 657000001724900004
2 10616832 853016576 0 0 64 664000000517600167
2 10616832 863633408 0 0 64 664000000517600167
2 10616832 874250240 0 0 64 664000000517600167
2 10616832 884867072 0 0 64 664000000517600167
2 10616832 895483904 0 0 64 664000000517600167
2 10616832 906100736 0 0 64 664000000517600167
2 10616832 916717568 0 0 64 664000000517600167
2 11010048 927334400 0 0 64 664000000517600167
2 11730944 938344448 0 0 64 673000000289600183
2 11730944 950075392 0 0 64 673000000289600183
2 11730944 961806336 0 0 64 673000000289600183
2 11730944 973537280 0 0 64 673000000289600183
2 11730944 985268224 0 0 64 673000000289600183
2 11730944 996999168 0 0 64 673000000289600183
2 11730944 1008730112 0 0 64 673000000289600183
2 11730944 1020461056 0 0 64 673000000289600183
2 12845056 1032192000 0 0 64 678000001093600058
2 12845056 1045037056 0 0 64 678000001093600058
2 12845056 1057882112 0 0 64 678000001093600058
2 12845056 1070727168 0 0 64 678000001093600058
2 12845056 1083572224 0 0 64 678000001093600058
2 12845056 1096417280 0 0 64 678000001093600058
2 12845056 1109262336 0 0 64 678000001093600058
2 13303808 1122107392 0 0 64 678000001093600058
2 14155776 1135411200 0 0 64 687000000265600182
2 14155776 1149566976 0 0 64 687000000265600182
2 14155776 1163722752 0 0 64 687000000265600182
2 14155776 1177878528 0 0 64 687000000265600182
2 14155776 1192034304 0 0 64 687000000265600182
2 14155776 1206190080 0 0 64 687000000265600182
2 14155776 1220345856 0 0 64 687000000265600182
2 14483456 1234501632 0 0 64 687000000265600182
2 15597568 1248985088 0 0 64 696000000241600183
2 15597568 1264582656 0 0 64 696000000241600183
2 15597568 1280180224 0 0 64 696000000241600183
2 15597568 1295777792 0 0 64 696000000241600183
2 15597568 1311375360 0 0 64 696000000241600183
2 15597568 1326972928 0 0 64 696000000241600183
2 15597568 1342570496 0 0 64 696000000241600183
2 15728640 1358168064 0 0 64 696000000241600183
2 17170432 1373896704 0 0 64 705000001153600229
2 17170432 1391067136 0 0 64 705000001153600229
2 17170432 1408237568 0 0 64 705000001153600229
2 17170432 1425408000 0 0 64 705000001153600229
2 17170432 1442578432 0 0 64 705000001153600229
2 17170432 1459748864 0 0 64 705000001153600229
2 17170432 1476919296 0 0 64 705000001153600229
2 17235968 1494089728 0 0 64 705000001153600229
2 18874368 1511325696 0 0 64 712000001683900060
2 18874368 1530200064 0 0 64 712000001683900060
2 18874368 1549074432 0 0 64 712000001683900060
2 18874368 1567948800 0 0 64 712000001683900060
2 18874368 1586823168 0 0 64 712000001683900060
2 18874368 1605697536 0 0 64 712000001683900060
2 18874368 1624571904 0 0 64 712000001683900060
2 19005440 1643446272 0 0 64 712000001683900060
2 20774912 1662451712 0 0 64 721000003662300264
2 20774912 1683226624 0 0 64 721000003662300264
2 20774912 1704001536 0 0 64 721000003662300264
2 20774912 1724776448 0 0 64 721000003662300264
2 20774912 1745551360 0 0 64 721000003662300264
2 20774912 1766326272 0 0 64 721000003662300264
2 20774912 1787101184 0 0 64 721000003662300264
2 20840448 1807876096 0 0 64 721000003662300264
2 22806528 1828716544 0 0 64 728000002617600192
2 22806528 1851523072 0 0 64 728000002617600192
2 22806528 1874329600 0 0 64 728000002617600192
2 22806528 1897136128 0 0 64 728000002617600192
2 22806528 1919942656 0 0 64 728000002617600192
2 22806528 1942749184 0 0 64 728000002617600192
2 22806528 1965555712 0 0 64 728000002617600192
2 23265280 1988362240 0 0 64 728000002617600192
2 25100288 2011627520 0 0 64 737000000265600041
2 25100288 2036727808 0 0 64 737000000265600041
2 25100288 2061828096 0 0 64 737000000265600041
2 25100288 2086928384 0 0 64 737000000265600041
2 25100288 2112028672 0 0 64 737000000265600041
2 25100288 2137128960 0 0 64 737000000265600041
2 25100288 2162229248 0 0 64 737000000265600041
2 25493504 2187329536 0 0 64 737000000265600041
2 27656192 2212823040 0 0 64 741000001069600011
2 27656192 2240479232 0 0 64 741000001069600011
2 27656192 2268135424 0 0 64 741000001069600011
2 27656192 2295791616 0 0 64 741000001069600011
2 27656192 2323447808 0 0 64 741000001069600011
2 27656192 2351104000 0 0 64 741000001069600011
2 27656192 2378760192 0 0 64 741000001069600011
2 27721728 2406416384 0 0 64 741000001069600011
2 30408704 2434138112 0 0 64 747000000481600185
2 30408704 2464546816 0 0 64 747000000481600185
2 30408704 2494955520 0 0 64 747000000481600185
2 30408704 2525364224 0 0 64 747000000481600185
2 30408704 2555772928 0 0 64 747000000481600185
2 30408704 2586181632 0 0 64 747000000481600185
2 30408704 2616590336 0 0 64 747000000481600185
2 30605312 2646999040 0 0 64 747000000481600185
2 33423360 2677604352 0 0 64 750000003745600222
2 33423360 2711027712 0 0 64 750000003745600222
2 33423360 2744451072 0 0 64 750000003745600222
2 33423360 2777874432 0 0 64 750000003745600222
2 33423360 2811297792 0 0 64 750000003745600222
2 33423360 2844721152 0 0 64 750000003745600222
2 33423360 2878144512 0 0 64 750000003745600222
2 33816576 2911567872 0 0 64 750000003745600222
2 36765696 2945384448 0 0 64 768000005746700222

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2006-08-17 : 16:22:22
How often are you backing up the transaction log?

Tara Kizer
Go to Top of Page

jung1975
Aged Yak Warrior

503 Posts
Posted - 2006-08-17 : 18:16:59
we are backing up the transaction log every hour
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2006-08-17 : 18:22:19
How big is the MDF file? How big is the LDF file? How much space is in use in the LDF file just prior to the tlog backup?

Tara Kizer
Go to Top of Page

jung1975
Aged Yak Warrior

503 Posts
Posted - 2006-08-17 : 18:34:15
here is the example

Dev_Finance 1 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Finance_Apps.mdf PRIMARY 416384 KB Unlimited 10% data only
Dev_Finance_log 2 C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Finance_Apps_log.ldf NULL 2912256 KB Unlimited 10% log only
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site