March 16, 2017 at 8:43 am
hi
we hae a log file that i cant reduce in size after it got slighty out of control
i have backed up the DB, and done log backups, then tried shrinking the log file but it wont budge
when i look at the log info i have the below...
any ideas what i can do to reduce the size further? as we have some app issues and i want to rule this out as being an issue
FileId FileSize StartOffset FSeqNo Status Parity CreateLSN
2 253952 8192 122244 2 128 0
2 253952 262144 122245 2 64 0
2 253952 516096 122242 2 128 0
2 278528 770048 122243 2 128 0
2 13107200 1048576 122300 2 128 98751000000023900003
2 13107200 14155776 122301 2 128 98751000000023900003
2 13107200 27262976 122248 2 64 98751000000023900003
2 13107200 40370176 122249 2 64 98751000000023900003
2 13107200 53477376 122250 2 64 98751000000023900003
2 13107200 66584576 122251 2 64 98751000000023900003
2 13107200 79691776 122252 2 64 98751000000023900003
2 13107200 92798976 122253 2 64 98751000000023900003
2 13107200 105906176 122254 2 64 98755000001081600538
2 13107200 119013376 122255 2 64 98755000001081600538
2 13107200 132120576 122256 2 64 98755000001081600538
2 13107200 145227776 122257 2 64 98755000001081600538
2 13107200 158334976 122258 2 64 98755000001081600538
2 13107200 171442176 122295 2 64 98755000001081600538
2 13107200 184549376 122298 2 64 98755000001081600538
2 13107200 197656576 122299 2 64 98755000001081600538
2 13107200 210763776 122259 2 128 98864000001099600123
2 13107200 223870976 122260 2 128 98864000001099600123
2 13107200 236978176 122261 2 128 98864000001099600123
2 13107200 250085376 122262 2 128 98864000001099600123
2 13107200 263192576 122263 2 128 98864000001099600123
2 13107200 276299776 122264 2 128 98864000001099600123
2 13107200 289406976 122265 2 128 98864000001099600123
2 13107200 302514176 122266 2 128 98864000001099600123
2 13107200 315621376 122267 2 128 98867000001753600431
2 13107200 328728576 122268 2 128 98867000001753600431
2 13107200 341835776 122269 2 128 98867000001753600431
2 13107200 354942976 122270 2 128 98867000001753600431
2 13107200 368050176 122271 2 128 98867000001753600431
2 13107200 381157376 122272 2 128 98867000001753600431
2 13107200 394264576 122273 2 128 98867000001753600431
2 13107200 407371776 122274 2 128 98867000001753600431
2 13107200 420478976 122275 2 128 98878000001597600546
2 13107200 433586176 122276 2 128 98878000001597600546
2 13107200 446693376 122277 2 128 98878000001597600546
2 13107200 459800576 122278 2 128 98878000001597600546
2 13107200 472907776 122279 2 128 98878000001597600546
2 13107200 486014976 122280 2 128 98878000001597600546
2 13107200 499122176 122281 2 128 98878000001597600546
2 13107200 512229376 122294 2 128 98878000001597600546
2 32833536 525336576 122282 2 64 119475000000757600522
2 32833536 558170112 122283 2 64 119475000000757600522
2 32833536 591003648 122284 2 64 119475000000757600522
2 32833536 623837184 122285 2 64 119475000000757600522
2 32833536 656670720 122286 2 64 119475000000757600522
2 32833536 689504256 122287 2 64 119475000000757600522
2 32833536 722337792 122288 2 64 119475000000757600522
2 32833536 755171328 122289 2 64 119475000000757600522
2 49217536 788004864 122290 2 64 119484000000493600523
2 49217536 837222400 122291 2 64 119484000000493600523
2 49217536 886439936 122292 2 64 119484000000493600523
2 49217536 935657472 122293 2 64 119484000000493600523
2 49217536 984875008 122296 2 64 119484000000493600523
2 49217536 1034092544 122297 2 64 119484000000493600523
2 49217536 1083310080 122302 2 64 119484000000493600523
2 49479680 1132527616 122303 2 64 119484000000493600523
2 73859072 1182007296 122304 2 64 119504000000517600351
2 73859072 1255866368 122305 2 64 119504000000517600351
2 73859072 1329725440 122306 2 64 119504000000517600351
2 73859072 1403584512 122307 2 64 119504000000517600351
2 73859072 1477443584 122308 2 64 119504000000517600351
2 73859072 1551302656 122309 2 64 119504000000517600351
2 73859072 1625161728 122310 2 64 119504000000517600351
2 73990144 1699020800 122311 2 64 119504000000517600351
2 110755840 1773010944 122312 2 64 119512000009761800024
2 110755840 1883766784 122313 2 64 119512000009761800024
2 110755840 1994522624 122314 2 64 119512000009761800024
2 110755840 2105278464 122315 2 64 119512000009761800024
2 110755840 2216034304 122316 2 64 119512000009761800024
2 110755840 2326790144 122317 2 64 119512000009761800024
2 110755840 2437545984 122318 2 64 119512000009761800024
2 111214592 2548301824 122319 2 64 119512000009761800024
2 83099648 2659516416 122320 2 64 119520000016213100527
2 83099648 2742616064 122321 2 64 119520000016213100527
2 83099648 2825715712 122322 2 64 119520000016213100527
2 83099648 2908815360 122323 2 64 119520000016213100527
2 83099648 2991915008 122324 2 64 119520000016213100527
2 83099648 3075014656 122325 2 64 119520000016213100527
2 83099648 3158114304 122326 2 64 119520000016213100527
2 83099648 3241213952 122327 2 64 119520000016213100527
2 83099648 3324313600 122328 2 64 119520000016213100527
2 83099648 3407413248 122329 2 64 119520000016213100527
2 83099648 3490512896 122330 2 64 119520000016213100527
2 83099648 3573612544 122331 2 64 119520000016213100527
2 83099648 3656712192 122332 2 64 119520000016213100527
2 83099648 3739811840 122333 2 64 119520000016213100527
2 83099648 3822911488 122334 2 64 119520000016213100527
2 83296256 3906011136 122351 2 64 119520000016213100527
2 124649472 3989307392 122335 2 64 119719000016030500525
2 124649472 4113956864 122336 2 64 119719000016030500525
2 124649472 4238606336 122337 2 64 119719000016030500525
2 124649472 4363255808 122338 2 64 119719000016030500525
2 124649472 4487905280 122339 2 64 119719000016030500525
2 124649472 4612554752 122340 2 64 119719000016030500525
2 124649472 4737204224 122341 2 64 119719000016030500525
2 124649472 4861853696 122342 2 64 119719000016030500525
2 124649472 4986503168 122343 2 64 119719000016030500525
2 124649472 5111152640 122344 2 64 119719000016030500525
2 124649472 5235802112 122345 2 64 119719000016030500525
2 124649472 5360451584 122346 2 64 119719000016030500525
2 124649472 5485101056 122347 2 64 119719000016030500525
2 124649472 5609750528 122348 2 64 119719000016030500525
2 124649472 5734400000 122349 2 64 119719000016030500525
2 124911616 5859049472 122350 2 64 119719000016030500525
2 186974208 5983961088 122352 2 64 119736000000451700370
2 186974208 6170935296 122353 2 64 119736000000451700370
2 186974208 6357909504 122354 2 64 119736000000451700370
2 186974208 6544883712 122355 2 64 119736000000451700370
2 186974208 6731857920 122356 2 64 119736000000451700370
2 186974208 6918832128 122241 2 128 119736000000451700370
2 186974208 7105806336 122246 2 128 119736000000451700370
2 186974208 7292780544 122247 2 128 119736000000451700370
2 233701376 7479754752 122357 2 64 122356000036471900001
2 241041408 7713456128 122358 2 64 122357000045592100003
2 65536000 7954497536 122359 2 64 122358000047021700005
2 65536000 8020033536 122360 2 64 122359000012730500004
2 65536000 8085569536 122361 2 64 122360000012749900003
2 65536000 8151105536 122362 2 64 122361000012722300004
2 65536000 8216641536 122363 2 64 122362000012742200004
2 65536000 8282177536 122364 2 64 122363000012744600003
2 65536000 8347713536 122365 2 64 122363000012744600003
2 65536000 8413249536 122366 2 64 122363000012744600003
2 65536000 8478785536 122367 2 64 122363000012744600003
2 65536000 8544321536 122368 2 64 122363000012744600003
2 65536000 8609857536 122369 2 64 122363000012744600003
2 65536000 8675393536 122370 2 64 122363000012744600003
2 65536000 8740929536 122371 2 64 122363000012744600003
2 65536000 8806465536 122372 2 64 122370000002113600395
2 65536000 8872001536 122373 2 64 122370000002113600395
2 65536000 8937537536 122374 2 64 122373000012726100004
2 65536000 9003073536 0 0 0 122373000012726100004
2 65536000 9068609536 0 0 0 122373000012726100004
2 65536000 9134145536 0 0 0 122373000012726100004
2 65536000 9199681536 0 0 0 122373000012726100004
2 65536000 9265217536 0 0 0 122373000012726100004
2 65536000 9330753536 0 0 0 122373000012726100004
2 65536000 9396289536 0 0 0 122373000012726100004
March 16, 2017 at 8:59 am
What is the log_reuse_wait desc for that database (in sys.databases)?
March 16, 2017 at 9:01 am
Sue
March 17, 2017 at 3:46 am
ah yes my db is full of what seems dead end connections, i knew i was forgetting something!!
thanks guys - again
March 21, 2017 at 4:36 am
closed the open transactions, which in reality are down to poor application design, and i could sort out the log file as expected
thanks
mal
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply