Post reply

DBCC SHRINKFILE

  • June 16, 2009 at 5:13 am

    #384779

    If i shrink the transaction log file..

    wat is the impact on database..

    wat i can do after shriking the log file.

    Can i restore the transaction log backups which are taken after shrinking on full backup which is taken before shrinking?

    thanks in advance

    GaNeSH

  • June 16, 2009 at 5:20 am

    #1010097

    HI Gansh,

    When you shrink the Log file, the Log file size is reduced to its initial size or size till which it holds the data currently which ever is more. Needless to say that once this is filled the File size is again incremented.

    When the file is shrunk and again expanded there will be some stress on the server to perform this activity. So unless required its always good to leave it as it is

    You can restore Full backups taken before shrinking the file and Log backups that were taken after shrinking the file

    Hope that answers your questions

    Thanks,

    Mani

  • June 16, 2009 at 6:32 am

    #1010123

    Thanks

    GaNeSH

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply