Professional Web Applications Themes

Using a network drive to hold databases - Microsoft SQL / MS SQL Server

I am trying to create a Db on a network drive from my SQL server 2000 Box. When I try to create the Db it tells me the MDF is on a network drive not supported for database files. Can anyone tell me how to get the network drive to support database files? Thanks, joe...

  1. #1

    Default Using a network drive to hold databases

    I am trying to create a Db on a network drive from my SQL
    server 2000 Box. When I try to create the Db it tells me
    the MDF is on a network drive not supported for database
    files.

    Can anyone tell me how to get the network drive to support
    database files?

    Thanks,
    joe

    Joe Guest

  2. #2

    Default Re: Using a network drive to hold databases

    Joe,

    Its supported via trace flag 1807, but not recommended.Refer

    INF: Support for Network Database Files
    http://support.microsoft.com/?id=304261


    Q. Can I create SQL Server databases on network drives?
    http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14285


    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "Joe" <com> wrote in message
    news:027101c34b0e$ef444540$gbl... 


    Dinesh.T.K Guest

Similar Threads

  1. Saving PDF on Network drive
    By Gene_Wolf@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 2
    Last Post: May 19th, 06:04 PM
  2. Network Drive
    By tk in forum Windows Networking
    Replies: 1
    Last Post: July 9th, 10:07 PM
  3. Mapping a Network Drive
    By JohnV in forum Windows XP/2000/ME
    Replies: 1
    Last Post: July 9th, 01:59 AM
  4. Using CD Drive Over Network
    By Joe Santana in forum Windows Networking
    Replies: 0
    Last Post: July 6th, 02:31 AM
  5. Mounting A Network Drive
    By Mike in forum Windows Networking
    Replies: 0
    Last Post: July 3rd, 06:09 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139