I have two transaction logs. one is 95 gigs and the other is 10gig I would like to remove the 10gig

Question

Post reply

I have two transaction logs. one is 95 gigs and the other is 10gig I would like to remove the 10gig

twdavis-893252

Ten Centuries

Points: 1195
More actions
February 6, 2012 at 11:48 am

#254957

I have two transaction logs for my main production database. one is 95 gigs and the other is 10gig I would like to remove the 10gig. What would be the safest way to do this?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 1

There's only really one way.

When there is no portion of the active log in the file you want to remove, you can just ALTER DATABASE ... REMOVE FILE.

DBCC loginfo shows the active and inactive VLFs (active has a status of 2, inactive of 0) and there's a fileid in there.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

twdavis-893252 Ten Centuries Points: 1195 More actions · Answer 2

if I DBCC loginfo from the master I get

FileIdFileSz Start FSeqNoStatusParityCreateLSN

2253952 8192 27923 01280

2262144 262144 27924 01280

2262144 524288 27928 26416683000000024000006

2262144 786432 27925 012816686000000024800001

2262144 104857 27926 212816687000000024000005

2262144 131072 27927 212816688000000024800001

so what does that tell me????

Thanks for your help

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 3

That the master database has a single log file (only 1 file ID), that single log file has 6 VLFs (6 rows), the 3rd, 5th and 6th are active (they have a status of 2) and the others are inactive.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

twdavis-893252 Ten Centuries Points: 1195 More actions · Answer 4

If I run it on the production database I wont to remove the extra logfile from I get.

status =0 on all????

FileId FileSize StartOffset FSeqNo Status Parity CreateLSN

----------- -------------------- -------------------- ----------- ----------- ------ ---------------------------------------

2 253952 8192 48304 0 64 0

2 253952 262144 48383 0 64 0

2 253952 516096 48384 0 64 0

2 278528 770048 48385 0 64 0

2 262144 1048576 48305 0 128 54000000030700376

2 262144 1310720 48386 0 128 68000000011200901

2 262144 1572864 48303 0 64 93000000016200331

2 262144 1835008 48322 0 64 96000000029600446

2 262144 2097152 48382 0 64 97000000031800131

2 262144 2359296 48387 0 64 156000000045900135

2 262144 2621440 48477 0 64 197000000019200030

2 327680 2883584 48302 0 128 198000000015000121

2 327680 3211264 48323 0 64 239000000020300279

2 393216 3538944 48381 0 64 240000000048000002

2 393216 3932160 48388 0 128 261000000017900039

2 458752 4325376 48324 0 128 314000000030100101

2 253952 4784128 48325 0 128 315000000037900457

2 270336 5038080 48328 0 128 315000000037900457

2 253952 5308416 48326 0 128 460000000047200002

2 270336 5562368 48327 0 128 460000000047200002

2 253952 5832704 48263 0 64 672000000037600124

2 335872 6086656 48264 0 64 672000000037600124

2 253952 6422528 48265 0 64 673000000013600371

2 401408 6676480 48266 0 64 673000000013600371

2 253952 7077888 48267 0 64 674000000012900023

2 466944 7331840 48268 0 64 674000000012900023

2 253952 7798784 48269 0 64 676000000037600369

2 253952 8052736 48270 0 64 676000000037600369

2 278528 8306688 48271 0 64 676000000037600369

2 253952 8585216 48272 0 64 677000000001600374

2 253952 8839168 48273 0 64 677000000001600374

2 344064 9093120 48274 0 64 677000000001600374

2 253952 9437184 48275 0 64 678000000001600375

2 253952 9691136 48276 0 64 678000000001600375

2 475136 9945088 48277 0 64 678000000001600375

2 253952 10420224 48278 0 64 678000000061800044

2 253952 10674176 48279 0 64 678000000061800044

2 253952 10928128 48280 0 64 678000000061800044

2 286720 11182080 48281 0 64 678000000061800044

2 262144 11468800 48282 0 64 679000000025600195

2 262144 11730944 48283 0 64 679000000025600195

2 262144 11993088 48284 0 64 679000000025600195

2 393216 12255232 48285 0 64 679000000025600195

2 327680 12648448 48286 0 64 680000000037600372

2 327680 12976128 48287 0 64 680000000037600372

2 327680 13303808 48288 0 64 680000000037600372

2 327680 13631488 48289 0 64 680000000037600372

2 327680 13959168 48290 0 64 682000000013600372

2 327680 14286848 48291 0 64 682000000013600372

2 327680 14614528 48292 0 64 682000000013600372

2 458752 14942208 48293 0 64 682000000013600372

2 393216 15400960 48294 0 64 684000000001600246

2 393216 15794176 48295 0 64 684000000001600246

2 393216 16187392 48296 0 64 684000000001600246

2 393216 16580608 48301 0 64 684000000001600246

2 393216 16973824 48329 0 64 718000000025600415

2 393216 17367040 48330 0 64 718000000025600415

2 393216 17760256 48331 0 64 718000000025600415

2 524288 18153472 48380 0 64 718000000025600415

2 458752 18677760 48297 0 64 1886000000049600432

2 458752 19136512 48298 0 64 1886000000049600432

2 458752 19595264 48299 0 64 1886000000049600432

2 524288 20054016 48300 0 64 1886000000049600432

2 524288 20578304 48306 0 64 1895000000037600456

2 524288 21102592 48307 0 64 1895000000037600456

2 524288 21626880 48308 0 64 1895000000037600456

2 524288 22151168 48309 0 64 1895000000037600456

2 524288 22675456 48310 0 64 1897000000001600366

2 524288 23199744 48311 0 64 1897000000001600366

2 524288 23724032 48312 0 64 1897000000001600366

2 720896 24248320 48313 0 64 1897000000001600366

2 589824 24969216 48314 0 64 1898000000013600456

2 589824 25559040 48315 0 64 1898000000013600456

2 589824 26148864 48316 0 64 1898000000013600456

2 720896 26738688 48317 0 64 1898000000013600456

2 655360 27459584 48318 0 64 1899000000049600456

2 655360 28114944 48319 0 64 1899000000049600456

2 655360 28770304 48320 0 64 1899000000049600456

2 786432 29425664 48321 0 64 1899000000049600456

2 720896 30212096 48332 0 64 2079000000013600282

2 720896 30932992 48333 0 64 2079000000013600282

2 720896 31653888 48334 0 64 2079000000013600282

2 851968 32374784 48335 0 64 2079000000013600282

2 786432 33226752 48336 0 64 2081000000037600288

2 786432 34013184 48337 0 64 2081000000037600288

2 786432 34799616 48338 0 64 2081000000037600288

2 983040 35586048 48339 0 64 2081000000037600288

2 917504 36569088 48340 0 64 2261000000040700001

2 917504 37486592 48341 0 64 2261000000040700001

2 917504 38404096 48342 0 64 2261000000040700001

2 917504 39321600 48343 0 64 2261000000040700001

2 983040 40239104 48344 0 64 2264000000168900009

2 983040 41222144 48377 0 64 2264000000168900009

2 983040 42205184 48378 0 64 2264000000168900009

2 1114112 43188224 48379 0 64 2264000000168900009

2 1114112 44302336 48345 0 64 3596000000092900005

2 1114112 45416448 48346 0 64 3596000000092900005

2 1114112 46530560 48347 0 64 3596000000092900005

2 1114112 47644672 48348 0 64 3596000000092900005

2 1179648 48758784 48349 0 64 3600000000092800009

2 1179648 49938432 48350 0 64 3600000000092800009

2 1179648 51118080 48351 0 64 3600000000092800009

2 1376256 52297728 48352 0 64 3600000000092800009

2 1310720 53673984 48353 0 64 3604000000127200008

2 1310720 54984704 48354 0 64 3604000000127200008

2 1310720 56295424 48355 0 64 3604000000127200008

2 1441792 57606144 48356 0 64 3604000000127200008

2 1441792 59047936 48357 0 64 3608000000116400012

2 1441792 60489728 48358 0 64 3608000000116400012

2 1441792 61931520 48359 0 64 3608000000116400012

2 1572864 63373312 48360 0 64 3608000000116400012

2 1572864 64946176 48361 0 64 3612000000104800002

2 1572864 66519040 48362 0 64 3612000000104800002

2 1572864 68091904 48363 0 64 3612000000104800002

2 1769472 69664768 48364 0 64 3612000000104800002

2 1769472 71434240 48365 0 64 3616000000093500007

2 1769472 73203712 48366 0 64 3616000000093500007

2 1769472 74973184 48367 0 64 3616000000093500007

2 1835008 76742656 48368 0 64 3616000000093500007

2 1966080 78577664 48369 0 64 3620000000059100010

2 1966080 80543744 48370 0 64 3620000000059100010

2 1966080 82509824 48371 0 64 3620000000059100010

2 1966080 84475904 48372 0 64 3620000000059100010

2 2162688 86441984 48373 0 64 3624000000024500013

2 2162688 88604672 48374 0 64 3624000000024500013

2 2162688 90767360 48375 0 64 3624000000024500013

2 2162688 92930048 48376 0 64 3624000000024500013

2 2359296 95092736 48389 0 64 3640000000047600001

2 2359296 97452032 48390 0 64 3640000000047600001

2 2359296 99811328 48391 0 64 3640000000047600001

2 2424832 102170624 48392 0 64 3640000000047600001

2 2621440 104595456 48465 0 64 3644000000380400002

2 2621440 107216896 48466 0 64 3644000000380400002

2 2621440 109838336 48467 0 64 3644000000380400002

2 2621440 112459776 48468 0 64 3644000000380400002

2 2883584 115081216 48469 0 64 3648000000334500013

2 2883584 117964800 48470 0 64 3648000000334500013

2 2883584 120848384 48471 0 64 3648000000334500013

2 2883584 123731968 48472 0 64 3648000000334500013

2 3145728 126615552 48473 0 64 3652000000311800004

2 3145728 129761280 48474 0 64 3652000000311800004

2 3145728 132907008 48475 0 64 3652000000311800004

2 3276800 136052736 48476 0 64 3652000000311800004

2 3473408 139329536 48478 0 64 3657000000047200001

2 3473408 142802944 48479 0 64 3657000000047200001

2 3473408 146276352 48480 0 64 3657000000047200001

2 3538944 149749760 48481 0 64 3657000000047200001

2 3801088 153288704 48482 0 64 3661000000631300001

2 3801088 157089792 48483 0 64 3661000000631300001

2 3801088 160890880 48484 0 64 3661000000631300001

2 3932160 164691968 48485 0 64 3661000000631300001

2 4194304 168624128 48486 0 64 3665000000629000007

2 4194304 172818432 48487 0 64 3665000000629000007

2 4194304 177012736 48488 0 64 3665000000629000007

2 4325376 181207040 48489 0 64 3665000000629000007

2 4587520 185532416 48490 0 64 3669000000640300005

2 4587520 190119936 48491 0 64 3669000000640300005

2 4587520 194707456 48492 0 64 3669000000640300005

2 4784128 199294976 48493 0 64 3669000000640300005

2 5111808 204079104 48494 0 64 3673000000629400010

2 5111808 209190912 48495 0 64 3673000000629400010

2 5111808 214302720 48496 0 64 3673000000629400010

2 5111808 219414528 48497 0 64 3673000000629400010

2 5570560 224526336 48498 0 64 3677000000540700001

2 5570560 230096896 48499 0 64 3677000000540700001

2 5570560 235667456 48217 0 128 3677000000540700001

2 5767168 241238016 48218 0 128 3677000000540700001

2 6160384 247005184 48219 0 128 3681000000640000007

2 6160384 253165568 48220 0 128 3681000000640000007

2 6160384 259325952 48221 0 128 3681000000640000007

2 6225920 265486336 48222 0 128 3681000000640000007

2 6750208 271712256 48223 0 128 3685000000674200004

2 6750208 278462464 48224 0 128 3685000000674200004

2 6750208 285212672 48225 0 128 3685000000674200004

2 6946816 291962880 48226 0 128 3685000000674200004

2 7471104 298909696 48227 0 128 3689000000719800007

2 7471104 306380800 48236 0 128 3689000000719800007

2 7471104 313851904 48237 0 128 3689000000719800007

2 7471104 321323008 48238 0 128 3689000000719800007

2 8192000 328794112 48239 0 128 3693000000697000003

2 8192000 336986112 48240 0 128 3693000000697000003

2 8192000 345178112 48241 0 128 3693000000697000003

2 8323072 353370112 48242 0 128 3693000000697000003

2 9043968 361693184 48243 0 128 3697000000423400005

2 9043968 370737152 48244 0 128 3697000000423400005

2 9043968 379781120 48245 0 128 3697000000423400005

2 9043968 388825088 48246 0 128 3697000000423400005

2 9895936 397869056 48247 0 128 3701000000446200007

2 9895936 407764992 48248 0 128 3701000000446200007

2 9895936 417660928 48249 0 128 3701000000446200007

2 10092544 427556864 48250 0 128 3701000000446200007

2 10944512 437649408 48251 0 128 3705000001561100094

2 10944512 448593920 48252 0 128 3705000001561100094

2 10944512 459538432 48253 0 128 3705000001561100094

2 10944512 470482944 48254 0 128 3705000001561100094

2 11993088 481427456 48255 0 128 3708000001584100111

2 11993088 493420544 48256 0 128 3708000001584100111

2 11993088 505413632 48257 0 128 3708000001584100111

2 12189696 517406720 48258 0 128 3708000001584100111

2 13238272 529596416 48259 0 128 3712000000513600002

2 13238272 542834688 48260 0 128 3712000000513600002

2 13238272 556072960 48261 0 128 3712000000513600002

2 13238272 569311232 48262 0 128 3712000000513600002

2 14548992 582549504 48393 0 64 6892000000037600125

2 14548992 597098496 48394 0 64 6892000000037600125

2 14548992 611647488 48395 0 64 6892000000037600125

2 14614528 626196480 48396 0 64 6892000000037600125

2 15990784 640811008 48397 0 64 6894000002293500381

2 15990784 656801792 48398 0 64 6894000002293500381

2 15990784 672792576 48399 0 64 6894000002293500381

2 16121856 688783360 48400 0 64 6894000002293500381

2 8781824 704905216 48401 0 64 6896000002794700362

2 8781824 713687040 48402 0 64 6896000002794700362

2 8781824 722468864 48403 0 64 6896000002794700362

2 8781824 731250688 48404 0 64 6896000002794700362

2 8781824 740032512 48405 0 64 6896000002794700362

2 8781824 748814336 48406 0 64 6896000002794700362

2 8781824 757596160 48407 0 64 6896000002794700362

2 9043968 766377984 48408 0 64 6896000002794700362

2 9699328 775421952 48409 0 64 6899000000426600404

2 9699328 785121280 48410 0 64 6899000000426600404

2 9699328 794820608 48411 0 64 6899000000426600404

2 9699328 804519936 48412 0 64 6899000000426600404

2 9699328 814219264 48413 0 64 6899000000426600404

2 9699328 823918592 48414 0 64 6899000000426600404

2 9699328 833617920 48415 0 64 6899000000426600404

2 9699328 843317248 48416 0 64 6899000000426600404

2 10616832 853016576 48417 0 64 6901000001553500304

2 10616832 863633408 48418 0 64 6901000001553500304

2 10616832 874250240 48419 0 64 6901000001553500304

2 10616832 884867072 48420 0 64 6901000001553500304

2 10616832 895483904 48421 0 64 6901000001553500304

2 10616832 906100736 48422 0 64 6901000001553500304

2 10616832 916717568 48423 0 64 6901000001553500304

2 11010048 927334400 48424 0 64 6901000001553500304

2 11730944 938344448 48425 0 64 6906000001195200389

2 11730944 950075392 48426 0 64 6906000001195200389

2 11730944 961806336 48427 0 64 6906000001195200389

2 11730944 973537280 48428 0 64 6906000001195200389

2 11730944 985268224 48429 0 64 6906000001195200389

2 11730944 996999168 48430 0 64 6906000001195200389

2 11730944 1008730112 48431 0 64 6906000001195200389

2 11730944 1020461056 48432 0 64 6906000001195200389

2 12845056 1032192000 48433 0 64 6911000001449800348

2 12845056 1045037056 48434 0 64 6911000001449800348

2 12845056 1057882112 48435 0 64 6911000001449800348

2 12845056 1070727168 48436 0 64 6911000001449800348

2 12845056 1083572224 48437 0 64 6911000001449800348

2 12845056 1096417280 48438 0 64 6911000001449800348

2 12845056 1109262336 48439 0 64 6911000001449800348

2 13303808 1122107392 48440 0 64 6911000001449800348

2 14155776 1135411200 48441 0 64 6917000000013600416

2 14155776 1149566976 48442 0 64 6917000000013600416

2 14155776 1163722752 48443 0 64 6917000000013600416

2 14155776 1177878528 48444 0 64 6917000000013600416

2 14155776 1192034304 48445 0 64 6917000000013600416

2 14155776 1206190080 48446 0 64 6917000000013600416

2 14155776 1220345856 48447 0 64 6917000000013600416

2 14483456 1234501632 48448 0 64 6917000000013600416

2 15597568 1248985088 48449 0 64 6922000000553700046

2 15597568 1264582656 48450 0 64 6922000000553700046

2 15597568 1280180224 48451 0 64 6922000000553700046

2 15597568 1295777792 48452 0 64 6922000000553700046

2 15597568 1311375360 48453 0 64 6922000000553700046

2 15597568 1326972928 48454 0 64 6922000000553700046

2 15597568 1342570496 48455 0 64 6922000000553700046

2 15728640 1358168064 48456 0 64 6922000000553700046

2 17170432 1373896704 48457 0 64 6927000001749700368

2 17170432 1391067136 48458 0 64 6927000001749700368

2 17170432 1408237568 48459 0 64 6927000001749700368

2 17170432 1425408000 48460 0 64 6927000001749700368

2 17170432 1442578432 48461 0 64 6927000001749700368

2 17170432 1459748864 48462 0 64 6927000001749700368

2 17170432 1476919296 48463 0 64 6927000001749700368

2 17235968 1494089728 48464 0 64 6927000001749700368

2 18874368 1511325696 48500 0 64 6999000000481600383

2 18874368 1530200064 48501 0 64 6999000000481600383

2 18874368 1549074432 48502 0 64 6999000000481600383

2 18874368 1567948800 48503 0 64 6999000000481600383

2 18874368 1586823168 48504 0 64 6999000000481600383

2 18874368 1605697536 48505 0 64 6999000000481600383

2 18874368 1624571904 48506 0 64 6999000000481600383

2 19005440 1643446272 48507 0 64 6999000000481600383

2 20774912 1662451712 48508 0 64 7004000000264400126

2 20774912 1683226624 48509 0 64 7004000000264400126

2 20774912 1704001536 48510 0 64 7004000000264400126

2 20774912 1724776448 48511 0 64 7004000000264400126

2 20774912 1745551360 48512 0 64 7004000000264400126

2 20774912 1766326272 48168 0 128 7004000000264400126

2 20774912 1787101184 48169 0 128 7004000000264400126

2 20840448 1807876096 48170 0 128 7004000000264400126

2 22806528 1828716544 48171 0 128 7008000003201800348

2 22806528 1851523072 48172 0 128 7008000003201800348

2 22806528 1874329600 48173 0 128 7008000003201800348

2 22806528 1897136128 48174 0 128 7008000003201800348

2 22806528 1919942656 48175 0 128 7008000003201800348

2 22806528 1942749184 48176 0 128 7008000003201800348

2 22806528 1965555712 48177 0 128 7008000003201800348

2 23265280 1988362240 48178 0 128 7008000003201800348

2 25100288 2011627520 48179 0 128 7013000003000100395

2 25100288 2036727808 48180 0 128 7013000003000100395

2 25100288 2061828096 48181 0 128 7013000003000100395

2 25100288 2086928384 48182 0 128 7013000003000100395

2 25100288 2112028672 48183 0 128 7013000003000100395

2 25100288 2137128960 48184 0 128 7013000003000100395

2 25100288 2162229248 48185 0 128 7013000003000100395

2 25493504 2187329536 48186 0 128 7013000003000100395

2 27656192 2212823040 48187 0 128 7018000001353700114

2 27656192 2240479232 48188 0 128 7018000001353700114

2 27656192 2268135424 48189 0 128 7018000001353700114

2 27656192 2295791616 48190 0 128 7018000001353700114

2 27656192 2323447808 48191 0 128 7018000001353700114

2 27656192 2351104000 48192 0 128 7018000001353700114

2 27656192 2378760192 48193 0 128 7018000001353700114

2 27721728 2406416384 48194 0 128 7018000001353700114

2 30408704 2434138112 48195 0 128 7023000001100400336

2 30408704 2464546816 48196 0 128 7023000001100400336

2 30408704 2494955520 48197 0 128 7023000001100400336

2 30408704 2525364224 48198 0 128 7023000001100400336

2 30408704 2555772928 48199 0 128 7023000001100400336

2 30408704 2586181632 48200 0 128 7023000001100400336

2 30408704 2616590336 48201 0 128 7023000001100400336

2 30605312 2646999040 48202 0 128 7023000001100400336

2 33423360 2677604352 48203 0 128 7028000001115400413

2 33423360 2711027712 48204 0 128 7028000001115400413

2 33423360 2744451072 48205 0 128 7028000001115400413

2 33423360 2777874432 48206 0 128 7028000001115400413

2 33423360 2811297792 48207 0 128 7028000001115400413

2 33423360 2844721152 48208 0 128 7028000001115400413

2 33423360 2878144512 48209 0 128 7028000001115400413

2 33816576 2911567872 48210 0 128 7028000001115400413

2 36765696 2945384448 48211 0 128 7033000002784600408

2 36765696 2982150144 48212 0 128 7033000002784600408

2 36765696 3018915840 48213 0 128 7033000002784600408

2 36765696 3055681536 48214 0 128 7033000002784600408

2 36765696 3092447232 48215 0 128 7033000002784600408

2 36765696 3129212928 48216 0 128 7033000002784600408

2 39518208 3165978624 48526 0 128 10839000002557600393

2 39518208 3205496832 48527 0 128 10839000002557600393

2 39518208 3245015040 48528 0 128 10839000002557600393

2 39518208 3284533248 48529 0 128 10839000002557600393

2 39518208 3324051456 48530 0 128 10839000002557600393

2 39518208 3363569664 48531 0 128 10839000002557600393

2 39518208 3403087872 48532 0 128 10839000002557600393

2 39976960 3442606080 48533 0 128 10839000002557600393

2 43515904 3482583040 48542 0 128 10846000003768800080

2 43515904 3526098944 48543 0 128 10846000003768800080

2 43515904 3569614848 48544 0 128 10846000003768800080

2 43515904 3613130752 48545 0 128 10846000003768800080

2 43515904 3656646656 48546 0 128 10846000003768800080

2 43515904 3700162560 48547 0 128 10846000003768800080

2 43515904 3743678464 48548 0 128 10846000003768800080

2 43646976 3787194368 48549 0 128 10846000003768800080

2 47841280 3830841344 48558 0 128 10850000001813600652

2 47841280 3878682624 48559 0 128 10850000001813600652

2 47841280 3926523904 48560 0 128 10850000001813600652

2 47841280 3974365184 48561 0 128 10850000001813600652

2 47841280 4022206464 48153 0 64 10850000001813600652

2 47841280 4070047744 48154 0 64 10850000001813600652

2 47841280 4117889024 48155 0 64 10850000001813600652

2 48234496 4165730304 48156 0 64 10850000001813600652

2 52625408 4213964800 48562 0 128 17424000006294500201

2 52625408 4266590208 48563 0 128 17424000006294500201

2 52625408 4319215616 48564 0 128 17424000006294500201

2 52625408 4371841024 48565 0 128 17424000006294500201

2 52625408 4424466432 48566 0 128 17424000006294500201

2 52625408 4477091840 48567 0 128 17424000006294500201

2 52625408 4529717248 48568 0 128 17424000006294500201

2 53018624 4582342656 48569 0 128 17424000006294500201

2 57933824 4635361280 47921 0 64 17430000006025600216

2 57933824 4693295104 47922 0 64 17430000006025600216

2 57933824 4751228928 47923 0 64 17430000006025600216

2 57933824 4809162752 47924 0 64 17430000006025600216

2 57933824 4867096576 47925 0 64 17430000006025600216

2 57933824 4925030400 47926 0 64 17430000006025600216

2 57933824 4982964224 47927 0 64 17430000006025600216

2 57999360 5040898048 47928 0 64 17430000006025600216

2 63700992 5098897408 47937 0 64 17441000008605600201

2 63700992 5162598400 47938 0 64 17441000008605600201

2 63700992 5226299392 47939 0 64 17441000008605600201

2 63700992 5290000384 47940 0 64 17441000008605600201

2 63700992 5353701376 47941 0 64 17441000008605600201

2 63700992 5417402368 47942 0 64 17441000008605600201

2 63700992 5481103360 47943 0 64 17441000008605600201

2 64028672 5544804352 47944 0 64 17441000008605600201

2 70057984 5608833024 47953 0 64 17448000001369600201

2 70057984 5678891008 47954 0 64 17448000001369600201

2 70057984 5748948992 47955 0 64 17448000001369600201

2 70057984 5819006976 47956 0 64 17448000001369600201

2 70057984 5889064960 47957 0 64 17448000001369600201

2 70057984 5959122944 47958 0 64 17448000001369600201

2 70057984 6029180928 47959 0 64 17448000001369600201

2 70516736 6099238912 47960 0 64 17448000001369600201

2 77070336 6169755648 47969 0 64 17460000000168700082

2 77070336 6246825984 47970 0 64 17460000000168700082

2 77070336 6323896320 47971 0 64 17460000000168700082

2 77070336 6400966656 47972 0 64 17460000000168700082

2 77070336 6478036992 47973 0 64 17460000000168700082

2 77070336 6555107328 47974 0 64 17460000000168700082

2 77070336 6632177664 47975 0 64 17460000000168700082

2 77529088 6709248000 47976 0 64 17460000000168700082

2 84803584 6786777088 47985 0 64 17470000001729600187

2 84803584 6871580672 47986 0 64 17470000001729600187

2 84803584 6956384256 47987 0 64 17470000001729600187

2 84803584 7041187840 47988 0 64 17470000001729600187

2 84803584 7125991424 47989 0 64 17470000001729600187

2 84803584 7210795008 47990 0 64 17470000001729600187

2 84803584 7295598592 47991 0 64 17470000001729600187

2 85065728 7380402176 47992 0 64 17470000001729600187

2 93323264 7465467904 48001 0 64 17479000002809600188

2 93323264 7558791168 48002 0 64 17479000002809600188

2 93323264 7652114432 48003 0 64 17479000002809600188

2 93323264 7745437696 48004 0 64 17479000002809600188

2 93323264 7838760960 48005 0 64 17479000002809600188

2 93323264 7932084224 48006 0 64 17479000002809600188

2 93323264 8025407488 48007 0 64 17479000002809600188

2 93323264 8118730752 48008 0 64 17479000002809600188

2 102629376 8212054016 48017 0 64 17491000007753600161

2 102629376 8314683392 48018 0 64 17491000007753600161

2 102629376 8417312768 48019 0 64 17491000007753600161

2 102629376 8519942144 48020 0 64 17491000007753600161

2 102629376 8622571520 48021 0 64 17491000007753600161

2 102629376 8725200896 48022 0 64 17491000007753600161

2 102629376 8827830272 48023 0 64 17491000007753600161

2 102825984 8930459648 48024 0 64 17491000007753600161

2 112918528 9033285632 48033 0 64 17502000005666600122

2 112918528 9146204160 48034 0 64 17502000005666600122

2 112918528 9259122688 48035 0 64 17502000005666600122

2 112918528 9372041216 48036 0 64 17502000005666600122

2 112918528 9484959744 48037 0 64 17502000005666600122

2 112918528 9597878272 48038 0 64 17502000005666600122

2 112918528 9710796800 48039 0 64 17502000005666600122

2 112918528 9823715328 48040 0 64 17502000005666600122

2 124190720 9936633856 48049 0 64 17512000000325600216

2 124190720 10060824576 48050 0 64 17512000000325600216

2 124190720 10185015296 48051 0 64 17512000000325600216

2 124190720 10309206016 48052 0 64 17512000000325600216

2 124190720 10433396736 48053 0 64 17512000000325600216

2 124190720 10557587456 48054 0 64 17512000000325600216

2 124190720 10681778176 48055 0 64 17512000000325600216

2 124321792 10805968896 48056 0 64 17512000000325600216

2 68288512 10930290688 48065 0 64 17524000017934700075

2 68288512 10998579200 48066 0 64 17524000017934700075

2 68288512 11066867712 48067 0 64 17524000017934700075

2 68288512 11135156224 48068 0 64 17524000017934700075

2 68288512 11203444736 48069 0 64 17524000017934700075

2 68288512 11271733248 48070 0 64 17524000017934700075

2 68288512 11340021760 48071 0 64 17524000017934700075

2 68288512 11408310272 48072 0 64 17524000017934700075

2 68288512 11476598784 48073 0 64 17524000017934700075

2 68288512 11544887296 48074 0 64 17524000017934700075

2 68288512 11613175808 48075 0 64 17524000017934700075

2 68288512 11681464320 48076 0 64 17524000017934700075

2 68288512 11749752832 48077 0 64 17524000017934700075

2 68288512 11818041344 48078 0 64 17524000017934700075

2 68288512 11886329856 48079 0 64 17524000017934700075

2 68747264 11954618368 48080 0 64 17524000017934700075

2 75104256 12023365632 48089 0 64 17538000004608100199

2 75104256 12098469888 48090 0 64 17538000004608100199

2 75104256 12173574144 48091 0 64 17538000004608100199

2 75104256 12248678400 48092 0 64 17538000004608100199

2 75104256 12323782656 48093 0 64 17538000004608100199

2 75104256 12398886912 48094 0 64 17538000004608100199

2 75104256 12473991168 48095 0 64 17538000004608100199

2 75104256 12549095424 48096 0 64 17538000004608100199

2 75104256 12624199680 48097 0 64 17538000004608100199

2 75104256 12699303936 48098 0 64 17538000004608100199

2 75104256 12774408192 48099 0 64 17538000004608100199

2 75104256 12849512448 48100 0 64 17538000004608100199

2 75104256 12924616704 48101 0 64 17538000004608100199

2 75104256 12999720960 48102 0 64 17538000004608100199

2 75104256 13074825216 48103 0 64 17538000004608100199

2 75825152 13149929472 48104 0 64 17538000004608100199

2 82640896 13225754624 48113 0 64 17549000005194600077

2 82640896 13308395520 48114 0 64 17549000005194600077

2 82640896 13391036416 48115 0 64 17549000005194600077

2 82640896 13473677312 48116 0 64 17549000005194600077

2 82640896 13556318208 48117 0 64 17549000005194600077

2 82640896 13638959104 48118 0 64 17549000005194600077

2 82640896 13721600000 48119 0 64 17549000005194600077

2 82640896 13804240896 48120 0 64 17549000005194600077

2 82640896 13886881792 48121 0 64 17549000005194600077

2 82640896 13969522688 48122 0 64 17549000005194600077

2 82640896 14052163584 48123 0 64 17549000005194600077

2 82640896 14134804480 48124 0 64 17549000005194600077

2 82640896 14217445376 48125 0 64 17549000005194600077

2 82640896 14300086272 48126 0 64 17549000005194600077

2 82640896 14382727168 48127 0 64 17549000005194600077

2 82968576 14465368064 48128 0 64 17549000005194600077

2 90898432 14548336640 48137 0 64 17560000010294600209

2 90898432 14639235072 48138 0 64 17560000010294600209

2 90898432 14730133504 48139 0 64 17560000010294600209

2 90898432 14821031936 48140 0 64 17560000010294600209

2 90898432 14911930368 48141 0 64 17560000010294600209

2 90898432 15002828800 48142 0 64 17560000010294600209

2 90898432 15093727232 48143 0 64 17560000010294600209

2 90898432 15184625664 48144 0 64 17560000010294600209

2 90898432 15275524096 48145 0 64 17560000010294600209

2 90898432 15366422528 48146 0 64 17560000010294600209

2 90898432 15457320960 48147 0 64 17560000010294600209

2 90898432 15548219392 48148 0 64 17560000010294600209

2 90898432 15639117824 48149 0 64 17560000010294600209

2 90898432 15730016256 48150 0 64 17560000010294600209

2 90898432 15820914688 48151 0 64 17560000010294600209

2 91357184 15911813120 48152 0 64 17560000010294600209

2 100007936 16003170304 48582 0 128 18754000013795700208

2 100007936 16103178240 48583 0 128 18754000013795700208

2 100007936 16203186176 48584 0 128 18754000013795700208

2 100007936 16303194112 48585 0 128 18754000013795700208

2 100007936 16403202048 48586 0 128 18754000013795700208

2 100007936 16503209984 48587 0 128 18754000013795700208

2 100007936 16603217920 48588 0 128 18754000013795700208

2 100007936 16703225856 48589 0 128 18754000013795700208

2 100007936 16803233792 48590 0 128 18754000013795700208

2 100007936 16903241728 48591 0 128 18754000013795700208

2 100007936 17003249664 48592 0 128 18754000013795700208

2 100007936 17103257600 48593 0 128 18754000013795700208

2 100007936 17203265536 48594 0 128 18754000013795700208

2 100007936 17303273472 48595 0 128 18754000013795700208

2 100007936 17403281408 48596 0 128 18754000013795700208

2 100204544 17503289344 48597 0 128 18754000013795700208

2 109969408 17603493888 48606 0 128 18767000015028500018

2 109969408 17713463296 48607 0 128 18767000015028500018

2 109969408 17823432704 48704 0 128 18767000015028500018

2 109969408 17933402112 48705 0 128 18767000015028500018

2 109969408 18043371520 48706 0 128 18767000015028500018

2 109969408 18153340928 48707 0 128 18767000015028500018

2 109969408 18263310336 48708 0 128 18767000015028500018

2 109969408 18373279744 48709 0 128 18767000015028500018

2 109969408 18483249152 48710 0 128 18767000015028500018

2 109969408 18593218560 48711 0 128 18767000015028500018

2 109969408 18703187968 48712 0 128 18767000015028500018

2 109969408 18813157376 48713 0 128 18767000015028500018

2 109969408 18923126784 48714 0 128 18767000015028500018

2 109969408 19033096192 48715 0 128 18767000015028500018

2 109969408 19143065600 48716 0 128 18767000015028500018

2 110821376 19253035008 48717 0 128 18767000015028500018

2 120979456 19363856384 48726 0 128 18782000000901600200

2 120979456 19484835840 48727 0 128 18782000000901600200

2 120979456 19605815296 48728 0 128 18782000000901600200

2 120979456 19726794752 48729 0 128 18782000000901600200

2 120979456 19847774208 48730 0 128 18782000000901600200

2 120979456 19968753664 48731 0 128 18782000000901600200

2 120979456 20089733120 48732 0 128 18782000000901600200

2 120979456 20210712576 48733 0 128 18782000000901600200

2 120979456 20331692032 48734 0 128 18782000000901600200

2 120979456 20452671488 48735 0 128 18782000000901600200

2 120979456 20573650944 48736 0 128 18782000000901600200

2 120979456 20694630400 48737 0 128 18782000000901600200

2 120979456 20815609856 48738 0 128 18782000000901600200

2 120979456 20936589312 48739 0 128 18782000000901600200

2 120979456 21057568768 48740 0 128 18782000000901600200

2 121700352 21178548224 48741 0 128 18782000000901600200

2 133103616 21300248576 48750 0 128 18795000004549600145

2 133103616 21433352192 48751 0 128 18795000004549600145

2 133103616 21566455808 48752 0 128 18795000004549600145

2 133103616 21699559424 48753 0 128 18795000004549600145

2 133103616 21832663040 48754 0 128 18795000004549600145

2 133103616 21965766656 48755 0 128 18795000004549600145

2 133103616 22098870272 48756 0 128 18795000004549600145

2 133103616 22231973888 48757 0 128 18795000004549600145

2 133103616 22365077504 48758 0 128 18795000004549600145

2 133103616 22498181120 48759 0 128 18795000004549600145

2 133103616 22631284736 48760 0 128 18795000004549600145

2 133103616 22764388352 48761 0 128 18795000004549600145

2 133103616 22897491968 48762 0 128 18795000004549600145

2 133103616 23030595584 48763 0 128 18795000004549600145

2 133103616 23163699200 48764 0 128 18795000004549600145

2 133496832 23296802816 48765 0 128 18795000004549600145

2 146407424 23430299648 48774 0 128 18810000016394200217

2 146407424 23576707072 48775 0 128 18810000016394200217

2 146407424 23723114496 48776 0 128 18810000016394200217

2 146407424 23869521920 48777 0 128 18810000016394200217

2 146407424 24015929344 48778 0 128 18810000016394200217

2 146407424 24162336768 48779 0 128 18810000016394200217

2 146407424 24308744192 48780 0 128 18810000016394200217

2 146407424 24455151616 48781 0 128 18810000016394200217

2 146407424 24601559040 48782 0 128 18810000016394200217

2 146407424 24747966464 48783 0 128 18810000016394200217

2 146407424 24894373888 48784 0 128 18810000016394200217

2 146407424 25040781312 48785 0 128 18810000016394200217

2 146407424 25187188736 48786 0 128 18810000016394200217

2 146407424 25333596160 48787 0 128 18810000016394200217

2 146407424 25480003584 48788 0 128 18810000016394200217

2 146931712 25626411008 48789 0 128 18810000016394200217

2 161021952 25773342720 48798 0 128 18825000006948600017

2 161021952 25934364672 48799 0 128 18825000006948600017

2 161021952 26095386624 48800 0 128 18825000006948600017

2 161021952 26256408576 48801 0 128 18825000006948600017

2 161021952 26417430528 48802 0 128 18825000006948600017

2 161021952 26578452480 48803 0 128 18825000006948600017

2 161021952 26739474432 48804 0 128 18825000006948600017

2 161021952 26900496384 48805 0 128 18825000006948600017

2 161021952 27061518336 48806 0 128 18825000006948600017

2 161021952 27222540288 48807 0 128 18825000006948600017

2 161021952 27383562240 48808 0 128 18825000006948600017

2 161021952 27544584192 48809 0 128 18825000006948600017

2 161021952 27705606144 48810 0 128 18825000006948600017

2 161021952 27866628096 48811 0 128 18825000006948600017

2 161021952 28027650048 48812 0 128 18825000006948600017

2 162004992 28188672000 48813 0 128 18825000006948600017

2 177143808 28350676992 48814 0 128 18836000025913300070

2 177143808 28527820800 48815 0 128 18836000025913300070

2 177143808 28704964608 48816 0 128 18836000025913300070

2 177143808 28882108416 48817 0 128 18836000025913300070

2 177143808 29059252224 48818 0 128 18836000025913300070

2 177143808 29236396032 48819 0 128 18836000025913300070

2 177143808 29413539840 48820 0 128 18836000025913300070

2 177143808 29590683648 48821 0 128 18836000025913300070

2 177143808 29767827456 48822 0 128 18836000025913300070

2 177143808 29944971264 48823 0 128 18836000025913300070

2 177143808 30122115072 48824 0 128 18836000025913300070

2 177143808 30299258880 48825 0 128 18836000025913300070

2 177143808 30476402688 48826 0 128 18836000025913300070

2 177143808 30653546496 48827 0 128 18836000025913300070

2 177143808 30830690304 48828 0 128 18836000025913300070

2 177930240 31007834112 48829 0 128 18836000025913300070

2 194904064 31185764352 48830 0 128 18848000009589600183

2 194904064 31380668416 48831 0 128 18848000009589600183

2 194904064 31575572480 48832 0 128 18848000009589600183

2 194904064 31770476544 48833 0 128 18848000009589600183

2 194904064 31965380608 48834 0 128 18848000009589600183

2 194904064 32160284672 48835 0 128 18848000009589600183

2 194904064 32355188736 48836 0 128 18848000009589600183

2 194904064 32550092800 48837 0 128 18848000009589600183

2 194904064 32744996864 48838 2 128 18848000009589600183

2 194904064 32939900928 47830 0 64 18848000009589600183

2 194904064 33134804992 47831 0 64 18848000009589600183

2 194904064 33329709056 47832 0 64 18848000009589600183

2 194904064 33524613120 47833 0 64 18848000009589600183

2 194904064 33719517184 47834 0 64 18848000009589600183

2 194904064 33914421248 47835 0 64 18848000009589600183

2 195035136 34109325312 47836 0 64 18848000009589600183

2 214368256 34304360448 47837 0 64 18861000010009600173

2 214368256 34518728704 47838 0 64 18861000010009600173

2 214368256 34733096960 47839 0 64 18861000010009600173

2 214368256 34947465216 47840 0 64 18861000010009600173

2 214368256 35161833472 47841 0 64 18861000010009600173

2 214368256 35376201728 47842 0 64 18861000010009600173

2 214368256 35590569984 47843 0 64 18861000010009600173

2 214368256 35804938240 47844 0 64 18861000010009600173

2 214368256 36019306496 47845 0 64 18861000010009600173

2 214368256 36233674752 47846 0 64 18861000010009600173

2 214368256 36448043008 47847 0 64 18861000010009600173

2 214368256 36662411264 47848 0 64 18861000010009600173

2 214368256 36876779520 47849 0 64 18861000010009600173

2 214368256 37091147776 47850 0 64 18861000010009600173

2 214368256 37305516032 47851 0 64 18861000010009600173

2 214958080 37519884288 47852 0 64 18861000010009600173

2 235798528 37734842368 47869 0 64 18874000005545600226

2 235798528 37970640896 47870 0 64 18874000005545600226

2 235798528 38206439424 47871 0 64 18874000005545600226

2 235798528 38442237952 47872 0 64 18874000005545600226

2 235798528 38678036480 47873 0 64 18874000005545600226

2 235798528 38913835008 47874 0 64 18874000005545600226

2 235798528 39149633536 47875 0 64 18874000005545600226

2 235798528 39385432064 47876 0 64 18874000005545600226

2 235798528 39621230592 47877 0 64 18874000005545600226

2 235798528 39857029120 47878 0 64 18874000005545600226

2 235798528 40092827648 47879 0 64 18874000005545600226

2 235798528 40328626176 47880 0 64 18874000005545600226

2 235798528 40564424704 47881 0 64 18874000005545600226

2 235798528 40800223232 47882 0 64 18874000005545600226

2 235798528 41036021760 47883 0 64 18874000005545600226

2 236519424 41271820288 47884 0 64 18874000005545600226

2 259391488 41508339712 47885 0 64 18887000026724700132

2 259391488 41767731200 47886 0 64 18887000026724700132

2 259391488 42027122688 47887 0 64 18887000026724700132

2 259391488 42286514176 47888 0 64 18887000026724700132

2 259391488 42545905664 47889 0 64 18887000026724700132

2 259391488 42805297152 47890 0 64 18887000026724700132

2 259391488 43064688640 47891 0 64 18887000026724700132

2 259391488 43324080128 47892 0 64 18887000026724700132

2 259391488 43583471616 47893 0 64 18887000026724700132

2 259391488 43842863104 47894 0 64 18887000026724700132

2 259391488 44102254592 47895 0 64 18887000026724700132

2 259391488 44361646080 47896 0 64 18887000026724700132

2 259391488 44621037568 47897 0 64 18887000026724700132

2 259391488 44880429056 47898 0 64 18887000026724700132

2 259391488 45139820544 47899 0 64 18887000026724700132

2 259981312 45399212032 47900 0 64 18887000026724700132

2 285343744 45659193344 47901 0 64 18900000025592700197

2 285343744 45944537088 47902 0 64 18900000025592700197

2 285343744 46229880832 47903 0 64 18900000025592700197

2 285343744 46515224576 47904 0 64 18900000025592700197

2 285343744 46800568320 47905 0 64 18900000025592700197

2 285343744 47085912064 47906 0 64 18900000025592700197

2 285343744 47371255808 47907 0 64 18900000025592700197

2 285343744 47656599552 47908 0 64 18900000025592700197

2 285343744 47941943296 47909 0 64 18900000025592700197

2 285343744 48227287040 47910 0 64 18900000025592700197

2 285343744 48512630784 47911 0 64 18900000025592700197

2 285343744 48797974528 47912 0 64 18900000025592700197

2 285343744 49083318272 47913 0 64 18900000025592700197

2 285343744 49368662016 47914 0 64 18900000025592700197

2 285343744 49654005760 47915 0 64 18900000025592700197

2 285802496 49939349504 47916 0 64 18900000025592700197

2 313851904 50225152000 48608 0 64 30445000021121600216

2 313851904 50539003904 48609 0 64 30445000021121600216

2 313851904 50852855808 48610 0 64 30445000021121600216

2 313851904 51166707712 48611 0 64 30445000021121600216

2 313851904 51480559616 48612 0 64 30445000021121600216

2 313851904 51794411520 48613 0 64 30445000021121600216

2 313851904 52108263424 48614 0 64 30445000021121600216

2 313851904 52422115328 48615 0 64 30445000021121600216

2 313851904 52735967232 48616 0 64 30445000021121600216

2 313851904 53049819136 48617 0 64 30445000021121600216

2 313851904 53363671040 48618 0 64 30445000021121600216

2 313851904 53677522944 48619 0 64 30445000021121600216

2 313851904 53991374848 48620 0 64 30445000021121600216

2 313851904 54305226752 48621 0 64 30445000021121600216

2 313851904 54619078656 48622 0 64 30445000021121600216

2 314769408 54932930560 48623 0 64 30445000021121600216

2 345243648 55247699968 48624 0 64 30454000021553600215

2 345243648 55592943616 48625 0 64 30454000021553600215

2 345243648 55938187264 48626 0 64 30454000021553600215

2 345243648 56283430912 48627 0 64 30454000021553600215

2 345243648 56628674560 48628 0 64 30454000021553600215

2 345243648 56973918208 48629 0 64 30454000021553600215

2 345243648 57319161856 48630 0 64 30454000021553600215

2 345243648 57664405504 48631 0 64 30454000021553600215

2 345243648 58009649152 48632 0 64 30454000021553600215

2 345243648 58354892800 48633 0 64 30454000021553600215

2 345243648 58700136448 48634 0 64 30454000021553600215

2 345243648 59045380096 48635 0 64 30454000021553600215

2 345243648 59390623744 48636 0 64 30454000021553600215

2 345243648 59735867392 48637 0 64 30454000021553600215

2 345243648 60081111040 48638 0 64 30454000021553600215

2 346161152 60426354688 48639 0 64 30454000021553600215

2 379781120 60772515840 48640 0 64 30463000022417600201

2 379781120 61152296960 48641 0 64 30463000022417600201

2 379781120 61532078080 48642 0 64 30463000022417600201

2 379781120 61911859200 48643 0 64 30463000022417600201

2 379781120 62291640320 48644 0 64 30463000022417600201

2 379781120 62671421440 48645 0 64 30463000022417600201

2 379781120 63051202560 48646 0 64 30463000022417600201

2 379781120 63430983680 48647 0 64 30463000022417600201

2 379781120 63810764800 48648 0 64 30463000022417600201

2 379781120 64190545920 48649 0 64 30463000022417600201

2 379781120 64570327040 48650 0 64 30463000022417600201

2 379781120 64950108160 48651 0 64 30463000022417600201

2 379781120 65329889280 48652 0 64 30463000022417600201

2 379781120 65709670400 48653 0 64 30463000022417600201

2 379781120 66089451520 48654 0 64 30463000022417600201

2 380567552 66469232640 48655 0 64 30463000022417600201

2 417792000 66849800192 48656 0 64 30472000045123000110

2 417792000 67267592192 48657 0 64 30472000045123000110

2 417792000 67685384192 48658 0 64 30472000045123000110

2 417792000 68103176192 48659 0 64 30472000045123000110

2 417792000 68520968192 48660 0 64 30472000045123000110

2 417792000 68938760192 48661 0 64 30472000045123000110

2 417792000 69356552192 48662 0 64 30472000045123000110

2 417792000 69774344192 48663 0 64 30472000045123000110

2 417792000 70192136192 48664 0 64 30472000045123000110

2 417792000 70609928192 48665 0 64 30472000045123000110

2 417792000 71027720192 48666 0 64 30472000045123000110

2 417792000 71445512192 48667 0 64 30472000045123000110

2 417792000 71863304192 48668 0 64 30472000045123000110

2 417792000 72281096192 48669 0 64 30472000045123000110

2 417792000 72698888192 48670 0 64 30472000045123000110

2 418119680 73116680192 48671 0 64 30472000045123000110

2 459538432 73534799872 48672 0 64 30482000022561600158

2 459538432 73994338304 48673 0 64 30482000022561600158

2 459538432 74453876736 48674 0 64 30482000022561600158

2 459538432 74913415168 48675 0 64 30482000022561600158

2 459538432 75372953600 48676 0 64 30482000022561600158

2 459538432 75832492032 48677 0 64 30482000022561600158

2 459538432 76292030464 48678 0 64 30482000022561600158

2 459538432 76751568896 48679 0 64 30482000022561600158

2 459538432 77211107328 48680 0 64 30482000022561600158

2 459538432 77670645760 48681 0 64 30482000022561600158

2 459538432 78130184192 48682 0 64 30482000022561600158

2 459538432 78589722624 48683 0 64 30482000022561600158

2 459538432 79049261056 48684 0 64 30482000022561600158

2 459538432 79508799488 48685 0 64 30482000022561600158

2 459538432 79968337920 48686 0 64 30482000022561600158

2 460455936 80427876352 48687 0 64 30482000022561600158

2 505544704 80888332288 48688 0 64 30492000039227000201

2 505544704 81393876992 48689 0 64 30492000039227000201

2 505544704 81899421696 48690 0 64 30492000039227000201

2 505544704 82404966400 48691 0 64 30492000039227000201

2 505544704 82910511104 48692 0 64 30492000039227000201

2 505544704 83416055808 48693 0 64 30492000039227000201

2 505544704 83921600512 48694 0 64 30492000039227000201

2 505544704 84427145216 48695 0 64 30492000039227000201

2 505544704 84932689920 48696 0 64 30492000039227000201

2 505544704 85438234624 48697 0 64 30492000039227000201

2 505544704 85943779328 48698 0 64 30492000039227000201

2 505544704 86449324032 48699 0 64 30492000039227000201

2 505544704 86954868736 48700 0 64 30492000039227000201

2 505544704 87460413440 48701 0 64 30492000039227000201

2 505544704 87965958144 48702 0 64 30492000039227000201

2 505675776 88471502848 48703 0 64 30492000039227000201

2 556072960 88977178624 47853 0 128 30699000019142100307

2 556072960 89533251584 47854 0 128 30699000019142100307

2 556072960 90089324544 47855 0 128 30699000019142100307

2 556072960 90645397504 47856 0 128 30699000019142100307

2 556072960 91201470464 47857 0 128 30699000019142100307

2 556072960 91757543424 47858 0 128 30699000019142100307

2 556072960 92313616384 47859 0 128 30699000019142100307

2 556072960 92869689344 47860 0 128 30699000019142100307

2 556072960 93425762304 47861 0 128 30699000019142100307

2 556072960 93981835264 47862 0 128 30699000019142100307

2 556072960 94537908224 47863 0 128 30699000019142100307

2 556072960 95093981184 47864 0 128 30699000019142100307

2 556072960 95650054144 47865 0 128 30699000019142100307

2 556072960 96206127104 47866 0 128 30699000019142100307

2 556072960 96762200064 47867 0 128 30699000019142100307

2 556662784 97318273024 47868 0 128 30699000019142100307

3 131006464 8192 48228 0 128 0

3 131006464 131014656 48229 0 128 0

3 131006464 262021120 48230 0 128 0

3 131006464 393027584 48231 0 128 0

3 131006464 524034048 48232 0 128 0

3 131006464 655040512 48233 0 128 0

3 131006464 786046976 48234 0 128 0

3 131522560 917053440 48235 0 128 0

3 13107200 1048576000 48513 0 64 8248000007188900329

3 13107200 1061683200 48514 0 64 8248000007188900329

3 13107200 1074790400 48515 0 64 8248000007188900329

3 13107200 1087897600 48516 0 64 8248000007188900329

3 13107200 1101004800 48517 0 64 8248000007188900329

3 13107200 1114112000 48157 0 128 8248000007188900329

3 13107200 1127219200 48158 0 128 8248000007188900329

3 13107200 1140326400 48159 0 128 8248000007188900329

3 14417920 1153433600 48160 0 128 8254000001093600417

3 14417920 1167851520 48161 0 128 8254000001093600417

3 14417920 1182269440 48162 0 128 8254000001093600417

3 14417920 1196687360 48163 0 128 8254000001093600417

3 14417920 1211105280 48164 0 128 8254000001093600417

3 14417920 1225523200 48165 0 128 8254000001093600417

3 14417920 1239941120 48166 0 128 8254000001093600417

3 14417920 1254359040 48167 0 128 8254000001093600417

3 15859712 1268776960 48518 0 128 10836000002425600491

3 15859712 1284636672 48519 0 128 10836000002425600491

3 15859712 1300496384 48520 0 128 10836000002425600491

3 15859712 1316356096 48521 0 128 10836000002425600491

3 15859712 1332215808 48522 0 128 10836000002425600491

3 15859712 1348075520 48523 0 128 10836000002425600491

3 15859712 1363935232 48524 0 128 10836000002425600491

3 15859712 1379794944 48525 0 128 10836000002425600491

3 17432576 1395654656 48534 0 128 10845000003457600652

3 17432576 1413087232 48535 0 128 10845000003457600652

3 17432576 1430519808 48536 0 128 10845000003457600652

3 17432576 1447952384 48537 0 128 10845000003457600652

3 17432576 1465384960 48538 0 128 10845000003457600652

3 17432576 1482817536 48539 0 128 10845000003457600652

3 17432576 1500250112 48540 0 128 10845000003457600652

3 17563648 1517682688 48541 0 128 10845000003457600652

3 19136512 1535246336 48550 0 128 10849000000721600652

3 19136512 1554382848 48551 0 128 10849000000721600652

3 19136512 1573519360 48552 0 128 10849000000721600652

3 19136512 1592655872 48553 0 128 10849000000721600652

3 19136512 1611792384 48554 0 128 10849000000721600652

3 19136512 1630928896 48555 0 128 10849000000721600652

3 19136512 1650065408 48556 0 128 10849000000721600652

3 19595264 1669201920 48557 0 128 10849000000721600652

3 21102592 1688797184 48570 0 128 17428000009253600148

3 21102592 1709899776 48571 0 128 17428000009253600148

3 21102592 1731002368 48572 0 128 17428000009253600148

3 21102592 1752104960 48573 0 128 17428000009253600148

3 21102592 1773207552 47917 0 64 17428000009253600148

3 21102592 1794310144 47918 0 64 17428000009253600148

3 21102592 1815412736 47919 0 64 17428000009253600148

3 21168128 1836515328 47920 0 64 17428000009253600148

3 23199744 1857683456 47929 0 64 17438000001237600142

3 23199744 1880883200 47930 0 64 17438000001237600142

3 23199744 1904082944 47931 0 64 17438000001237600142

3 23199744 1927282688 47932 0 64 17438000001237600142

3 23199744 1950482432 47933 0 64 17438000001237600142

3 23199744 1973682176 47934 0 64 17438000001237600142

3 23199744 1996881920 47935 0 64 17438000001237600142

3 23396352 2020081664 47936 0 64 17438000001237600142

3 25493504 2043478016 47945 0 64 17446000004510200070

3 25493504 2068971520 47946 0 64 17446000004510200070

3 25493504 2094465024 47947 0 64 17446000004510200070

3 25493504 2119958528 47948 0 64 17446000004510200070

3 25493504 2145452032 47949 0 64 17446000004510200070

3 25493504 2170945536 47950 0 64 17446000004510200070

3 25493504 2196439040 47951 0 64 17446000004510200070

3 25886720 2221932544 47952 0 64 17446000004510200070

3 28049408 2247819264 47961 0 64 17458000000330700075

3 28049408 2275868672 47962 0 64 17458000000330700075

3 28049408 2303918080 47963 0 64 17458000000330700075

3 28049408 2331967488 47964 0 64 17458000000330700075

3 28049408 2360016896 47965 0 64 17458000000330700075

3 28049408 2388066304 47966 0 64 17458000000330700075

3 28049408 2416115712 47967 0 64 17458000000330700075

3 28442624 2444165120 47968 0 64 17458000000330700075

3 30867456 2472607744 47977 0 64 17465000001729600201

3 30867456 2503475200 47978 0 64 17465000001729600201

3 30867456 2534342656 47979 0 64 17465000001729600201

3 30867456 2565210112 47980 0 64 17465000001729600201

3 30867456 2596077568 47981 0 64 17465000001729600201

3 30867456 2626945024 47982 0 64 17465000001729600201

3 30867456 2657812480 47983 0 64 17465000001729600201

3 31195136 2688679936 47984 0 64 17465000001729600201

3 33947648 2719875072 47993 0 64 17477000000985600056

3 33947648 2753822720 47994 0 64 17477000000985600056

3 33947648 2787770368 47995 0 64 17477000000985600056

3 33947648 2821718016 47996 0 64 17477000000985600056

3 33947648 2855665664 47997 0 64 17477000000985600056

3 33947648 2889613312 47998 0 64 17477000000985600056

3 33947648 2923560960 47999 0 64 17477000000985600056

3 34406400 2957508608 48000 0 64 17477000000985600056

3 37355520 2991915008 48009 0 64 17489000007081600216

3 37355520 3029270528 48010 0 64 17489000007081600216

3 37355520 3066626048 48011 0 64 17489000007081600216

3 37355520 3103981568 48012 0 64 17489000007081600216

3 37355520 3141337088 48013 0 64 17489000007081600216

3 37355520 3178692608 48014 0 64 17489000007081600216

3 37355520 3216048128 48015 0 64 17489000007081600216

3 37748736 3253403648 48016 0 64 17489000007081600216

3 41091072 3291152384 48025 0 64 17497000000553600216

3 41091072 3332243456 48026 0 64 17497000000553600216

3 41091072 3373334528 48027 0 64 17497000000553600216

3 41091072 3414425600 48028 0 64 17497000000553600216

3 41091072 3455516672 48029 0 64 17497000000553600216

3 41091072 3496607744 48030 0 64 17497000000553600216

3 41091072 3537698816 48031 0 64 17497000000553600216

3 41484288 3578789888 48032 0 64 17497000000553600216

3 45219840 3620274176 48041 0 64 17509000011106800199

3 45219840 3665494016 48042 0 64 17509000011106800199

3 45219840 3710713856 48043 0 64 17509000011106800199

3 45219840 3755933696 48044 0 64 17509000011106800199

3 45219840 3801153536 48045 0 64 17509000011106800199

3 45219840 3846373376 48046 0 64 17509000011106800199

3 45219840 3891593216 48047 0 64 17509000011106800199

3 45481984 3936813056 48048 0 64 17509000011106800199

3 49741824 3982295040 48057 0 64 17522000014991300128

3 49741824 4032036864 48058 0 64 17522000014991300128

3 49741824 4081778688 48059 0 64 17522000014991300128

3 49741824 4131520512 48060 0 64 17522000014991300128

3 49741824 4181262336 48061 0 64 17522000014991300128

3 49741824 4231004160 48062 0 64 17522000014991300128

3 49741824 4280745984 48063 0 64 17522000014991300128

3 50069504 4330487808 48064 0 64 17522000014991300128

3 54722560 4380557312 48081 0 64 17534000003094900085

3 54722560 4435279872 48082 0 64 17534000003094900085

3 54722560 4490002432 48083 0 64 17534000003094900085

3 54722560 4544724992 48084 0 64 17534000003094900085

3 54722560 4599447552 48085 0 64 17534000003094900085

3 54722560 4654170112 48086 0 64 17534000003094900085

3 54722560 4708892672 48087 0 64 17534000003094900085

3 55050240 4763615232 48088 0 64 17534000003094900085

3 60227584 4818665472 48105 0 64 17544000008965600175

3 60227584 4878893056 48106 0 64 17544000008965600175

3 60227584 4939120640 48107 0 64 17544000008965600175

3 60227584 4999348224 48108 0 64 17544000008965600175

3 60227584 5059575808 48109 0 64 17544000008965600175

3 60227584 5119803392 48110 0 64 17544000008965600175

3 60227584 5180030976 48111 0 64 17544000008965600175

3 60293120 5240258560 48112 0 64 17544000008965600175

3 66256896 5300551680 48129 0 64 17558000000049600013

3 66256896 5366808576 48130 0 64 17558000000049600013

3 66256896 5433065472 48131 0 64 17558000000049600013

3 66256896 5499322368 48132 0 64 17558000000049600013

3 66256896 5565579264 48133 0 64 17558000000049600013

3 66256896 5631836160 48134 0 64 17558000000049600013

3 66256896 5698093056 48135 0 64 17558000000049600013

3 66256896 5764349952 48136 0 64 17558000000049600013

3 72876032 5830606848 48574 0 128 18750000001393600202

3 72876032 5903482880 48575 0 128 18750000001393600202

3 72876032 5976358912 48576 0 128 18750000001393600202

3 72876032 6049234944 48577 0 128 18750000001393600202

3 72876032 6122110976 48578 0 128 18750000001393600202

3 72876032 6194987008 48579 0 128 18750000001393600202

3 72876032 6267863040 48580 0 128 18750000001393600202

3 72941568 6340739072 48581 0 128 18750000001393600202

3 80150528 6413680640 48598 0 128 18764000009058100047

3 80150528 6493831168 48599 0 128 18764000009058100047

3 80150528 6573981696 48600 0 128 18764000009058100047

3 80150528 6654132224 48601 0 128 18764000009058100047

3 80150528 6734282752 48602 0 128 18764000009058100047

3 80150528 6814433280 48603 0 128 18764000009058100047

3 80150528 6894583808 48604 0 128 18764000009058100047

3 80347136 6974734336 48605 0 128 18764000009058100047

3 88145920 7055081472 48718 0 128 18777000006157600217

3 88145920 7143227392 48719 0 128 18777000006157600217

3 88145920 7231373312 48720 0 128 18777000006157600217

3 88145920 7319519232 48721 0 128 18777000006157600217

3 88145920 7407665152 48722 0 128 18777000006157600217

3 88145920 7495811072 48723 0 128 18777000006157600217

3 88145920 7583956992 48724 0 128 18777000006157600217

3 88539136 7672102912 48725 0 128 18777000006157600217

3 96993280 7760642048 48742 0 128 18791000011461600203

3 96993280 7857635328 48743 0 128 18791000011461600203

3 96993280 7954628608 48744 0 128 18791000011461600203

3 96993280 8051621888 48745 0 128 18791000011461600203

3 96993280 8148615168 48746 0 128 18791000011461600203

3 96993280 8245608448 48747 0 128 18791000011461600203

3 96993280 8342601728 48748 0 128 18791000011461600203

3 97124352 8439595008 48749 0 128 18791000011461600203

3 106692608 8536719360 48766 0 128 18806000015105000197

3 106692608 8643411968 48767 0 128 18806000015105000197

3 106692608 8750104576 48768 0 128 18806000015105000197

3 106692608 8856797184 48769 0 128 18806000015105000197

3 106692608 8963489792 48770 0 128 18806000015105000197

3 106692608 9070182400 48771 0 128 18806000015105000197

3 106692608 9176875008 48772 0 128 18806000015105000197

3 106823680 9283567616 48773 0 128 18806000015105000197

3 117374976 9390391296 48790 0 128 18820000018193600188

3 117374976 9507766272 48791 0 128 18820000018193600188

3 117374976 9625141248 48792 0 128 18820000018193600188

3 117374976 9742516224 48793 0 128 18820000018193600188

3 117374976 9859891200 48794 0 128 18820000018193600188

3 117374976 9977266176 48795 0 128 18820000018193600188

3 117374976 10094641152 48796 0 128 18820000018193600188

3 117440512 10212016128 48797 0 128 18820000018193600188

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 5

There is one VLF active:

2 194904064 32744996864 48838 2 128 18848000009589600183

The active VLF is in file 2, so you should be able to just ALTER DATABASE ... REMOVE FILE and remove the 2nd file.

Once you've done that, you may want to look at optimising the log. It looks like there are too many VLFs there.

http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

twdavis-893252 Ten Centuries Points: 1195 More actions · Answer 6

twdavis-893252

Ten Centuries

Points: 1195

February 6, 2012 at 2:14 pm

#1443435

Thanks You very much

I will try this tonight.

twdavis-893252 Ten Centuries Points: 1195 More actions · Answer 7

twdavis-893252

Ten Centuries

Points: 1195

February 6, 2012 at 2:21 pm

#1443439

Thanks You very much

I will try this tonight.

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 8

Cool, let me know how it goes.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

twdavis-893252 Ten Centuries Points: 1195 More actions · Answer 9

twdavis-893252

Ten Centuries

Points: 1195

February 7, 2012 at 7:05 am

#1443748

Worked perfectly with no trouble at all thanks