Post reply

Log file moving

  • December 20, 2012 at 7:29 am

    #286509

    Hello friends,

    I have a question that I have a database "Deparment" in my SQL Server 2008r2 environment It has Data files of 5GB and Logfile is 13GB.

    My question is Is that possible we can Move this 13GB log file to another location and create a new log file so that the further transaction can store in new log file which saves my space means my database size will 5 Gb in this scenerio.

    Wating for yours suggession?

    Thanks

    Jitendra

  • December 20, 2012 at 7:41 am

    #1570544

    You probably need to understand more about how log file works and how to manage it. See this link.

    http://www.sqlservercentral.com/articles/Administration/64582/%5B/URL%5D


    Pradeep Singh

  • December 20, 2012 at 7:53 am

    #1570549

    Let me guess... Full recovery model and no log backups. When maintained properly, the space in the log file is reusable. See the recommended article

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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