[dba-SQLServer] Shrinking Log File

Stephen Hait shait at mindspring.com
Tue Jan 17 09:28:56 CST 2006

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?


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

More information about the dba-SQLServer mailing list