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

  • 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

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

    Rohit

  • 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
  • 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.

  • 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
  • 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

  • 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 7 (of 7 total)

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