Any possibility to to attach database files on a mapped network drive?

  • Hi,

    i've tried to attach a database form a mapped network drive an i got the Error:

    "Server: Msg 5105, Level 16, State 2, Line1, Device activation error. The physical file name ...... may be incorrect."

    This devies runs on a cluster ressource on external storage. Which possibilities do i have to attach this database (without copying to a local drive)?

    Thanks in Advance

    Jürgen

  • have you tried UNC? \\computername\....

  • have you tried UNC? \\computername\....

  • Hi, yes i tried with this sql:

    EXEC sp_attach_db @dbname = N'CL2_TEST',

    @filename1 = N'\\sb-s-nt2a\t$\develop\data\CL2_TEST_Data.mdf',

    @filename2 = N'\\sb-s-nt2a\t$\develop\trnlog\CL2_TEST_Log.ldf'

    and i got this error:

    Server: Msg 5110, Level 16, State 2, Line 1

    File '\\sb-s-nt2a\t$\develop\data\CL2_TEST_Data.mdf' is on a network device not supported for database files.

    So i guess there is no additional option....

  • By default, you cannot have a database file (mdf, ndf, or log) on a networked drive.  Network drives are considered too slow to handle rigors of database transactional volumes, and SQL Server is not sure the write request actually gets done when going across a network.

    That said, there is a trace flag you can implement to allow networked drives.  Read this article for how to do that and other implications you need to consider:

    MSKB 304261: Description of support for network database files in SQL Server

    Hope this helps



    Mark

  • Hi Mark Harr,

    thank you for this link

  • In Sql Server 2005 your can turn on trace flag 1807.

Viewing 7 posts - 1 through 6 (of 6 total)

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