Post reply

transaction log on network share

  • September 3, 2010 at 7:41 am

    #223447

    As far as I know transaction log file that maps to a database cannot be put on network share. how would sql server know where is the network path e.g.

    \\whatsup\logfile\abc.ldf

    However I cant find any documentation from MS that says that.

    Wondering what other people think?

    thanks

  • September 3, 2010 at 7:56 am

    #1216172

    you have to use a trace flag to enable mounting database files on a network share. It isn't recommended at all. http://support.microsoft.com/kb/304261

  • September 3, 2010 at 8:06 am

    #1216180

    'Not recommended' is an understatement. It's an extremely bad idea. Do that and you're risking the integrity of the DB. A single network dip could make the DB unavailable or even suspect.

    SQL requires several things of the file system that its files are on. The network sharing does not ensure them.

    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

  • September 3, 2010 at 8:44 am

    #1216203

    I completely agree with Gail. DO NOT put database files on the network. The network is for sharing resources, but SQL does that for you. It allows multiple people to connect.

    Get enough local disk for your database.

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

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