Post reply

can data file(.mdf) and log file(.ldf) store in network drive

  • August 17, 2010 at 2:33 am

    #141538

    Hi

    We're using sql 2005 enterprise and want to store all the database files to network drive (i.e. \\<server name>\<path>) but without mounting drive to network or creating any share directory. Is it possible?

    Thanks and regards,

    Wallace

  • August 17, 2010 at 2:45 am

    #1207700

    I don't think this is possible..... but is there any specific reason for this??

    Rohit

  • August 17, 2010 at 2:50 am

    #1207703

    Not possible. SQL will not allow its files to be on a remote drive. The network file-share does not provide the IO guarantees that SQL requires.

    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

  • August 17, 2010 at 3:14 am

    #1207708

    Because we want to have only one network hard drive for storage rather than using any local drive and we don't want to mount drive and using network sharing. Thanks.

  • August 17, 2010 at 3:16 am

    #1207710

    You cannot put SQL's database files onto a network drive, regardless of whether you create a mapped drive or not. Files have to be on local storage, SAN storage or appropriately configured iSCSI.

    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

  • August 17, 2010 at 3:22 am

    #1207714

    GilaMonster (8/17/2010)

    You cannot put SQL's database files onto a network drive, regardless of whether you create a mapped drive or not. Files have to be on local storage, SAN storage or appropriately configured iSCSI.

    Thanks for your reply. Do you know is there any existing software that can integrate into SQL server 2005/2008 and provide network storage solutions?

    Thanks and regards,

    Wallace

  • August 17, 2010 at 3:28 am

    #1207715

    Not that I'm aware of.

    There is a traceflag that, if enabled will allow SQL to store files on the network, but it is strongly not recommended. Files on the network mean that a single network glitch could cause data corruptions, unavailable databases, crashes and the like. It is NOT a good idea, not recommended, not supported and should not be considered.

    Data files should be stored on local attached storage or SANs. Or look into iSCSI storage.

    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 7 posts - 1 through 6 (of 6 total)

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