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