Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    23

    Unanswered: Hosting an SQL database on remote share

    Hi,
    I would really appreciate help with this query.

    I have an SQL 2000 server setup with 2 databases. My boss would like to setup another database but wants the actual database to reside on a different server share.

    Is is possible for one database on an SQL server to be hosted on a remote share ?

    appreicate any info
    thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    It can be done, but it is difficult, complex, and unsupported. I wouldn't go there, the risk is way too high.

    -PatP

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Main point to think about is Performance and is there any reason why your boss is thinking in such a high-fly idea.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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