October 12, 2006 at 3:43 am
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
October 12, 2006 at 4:25 am
have you tried UNC? \\computername\....
October 12, 2006 at 4:25 am
have you tried UNC? \\computername\....
October 12, 2006 at 5:29 am
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....
October 12, 2006 at 5:52 am
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
October 12, 2006 at 6:32 am
Hi Mark Harr,
thank you for this link
October 13, 2006 at 8:14 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy