Home > Archive > microsoft.public.sqlserver.server > November 2002 > Size of first tran log after db dump





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Size of first tran log after db dump
John

2002-11-20, 4:23 pm

Why is it after I backup my 11gb db the first logfile is 2
to 3 times larger than the db?
chris

2002-11-20, 5:23 pm

Have you truncated the tlog lately?
"John" <spinach47@hotmail.com> wrote in message
news:ca5e01c290df$57125080$89f
82ecf@TK2MSFTNGXA01...
> Why is it after I backup my 11gb db the first logfile is 2
> to 3 times larger than the db?



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net