[dba-SQLServer] Shrinking Log File

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