Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    47

    Unanswered: install SQL over UNC path ?

    I want to setup a database that has the data and log files on a different server on the network. How do I do this?

    ex:
    \\other_server\c\mssql\data.mdf

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Exclamation Re: install SQL over UNC path ?

    I want to setup a database that has the data and log files on a different server on the network. How do I do this?

    ex:
    \\other_server\c\mssql\data.mdf
    Carefully; I can't really generally reccomend the practice as part of a general production configuration. Testing that kind of configuration a few years ago (ver 7.0) with connectivity failure tests (with network storage devices) ruled out the practice for many uses. On some systems it seems to be enabled already, while on others it will require enabling a trace flag (as per MS - can't remember which one off hand) beforehand.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •