[dba-SQLServer] Shrinking Log File

Are your log files growing astronomically after you restore and then delete
the logs? If so, see if you can determine what is causing the rapid growth.
A large number of table inserts or updates can cause log files to bloat so
if this is a frequent occurence, you should try to shrink the logs after
these operations.

Other than that, I'm not really sure.

Regards,
Stephen

On 1/17/06, David Emerson <newsgrps at dalyn.co.nz> wrote:
>
> I can (and did thanks to your help).  However, because they are 14GB
> in size I need to make sure I have that much spare space on my hard
> drive!  Also the fact that there is so much wasted space in the file
> (and I can't shrink it) is a cause for concern.  What else is waiting
> to jump out and bite me?
>
> David
>
> At 18/01/2006, you wrote:
> >I don't know why you have that situation. Do you actually need the log
> files
> >for anything? If not and you need to restore the associated data files,
> >couldn't you just get rid of them after the restore?
> >
> >Stephen
> >
> >On 1/16/06, David Emerson <newsgrps at dalyn.co.nz> wrote:
> > >
> > > Thanks Stephen.  That solved my immediate problem.
> > >
> > > Now my problem is that the files backed up from the end of last year
> > > are restoring fine with transaction logs in the size
> > > expected.  However, when I try to restore a back up file from this
> > > year (I have 2 from 2 different databases) the transaction log is way
> > > out of proportion to the actual size used (eg 13779MB in size with
> > > 113MB space used).  The original files on the server are closer to
> > > what I would expect them to be but for some reason the backups are
> > > not restoring well.
> > >
> > > Any thoughts on what went wrong.
> > >
> > > David
> > >
> > >
> >_______________________________________________
> >dba-SQLServer mailing list
> >dba-SQLServer at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> >http://www.databaseadvisors.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>