Re: Device activation error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Do not install SQL data files on a mapped network drive or a UNC share or
even an NAS box. The restriction is to prevent severe data corruption and
performance issues. Use local drives or SAN connected drives only for SQL
database files. The trace flag is for use with a very small set of NAS
servers only and can cause major problems if used anywhere else.

Geoff N. Hiten
Microsoft SQL Server MVP


"Pradeep" <Pradeep@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ACFEB1C7-4C27-4D7E-9D7D-10AB645FAC0C@xxxxxxxxxxxxxxxx
> Hi all,
> According to the requirement I need to install the database files
> on
> U:\ and T:\ which are mapped network drives. It is giving me the error
> "Device activation error. The physical file name
> 'T:\MSSQL$SQL01\data\product.mdf' may be incorrect."
>
> I found an article on knowledge base which says for security reasons SQL
> Server installation is not allowed in Mapped network drives but we can
> disable it temporarily with the help of Trace Flag 1807 using DBCC
> command.
>
> I tried that, after that also its not working.
>
> I used the following query
>
> USE MASTER
> DBCC TRACEON(1807)
> IF NOT EXISTS
> (
> SELECT name FROM master.dbo.sysdatabases WHERE name = N'ATEMS'
> )
> CREATE DATABASE ATEMS ON
> (NAME = ATEMS1, FILENAME='T:\MSSQL$SQL01\data\product.mdf', SIZE = 5,
> MAXSIZE = 6, FILEGROWTH = 1)
> LOG ON
> (NAME = ATEMSLOG1, FILENAME='U:\MSSQL$SQL01\Tlog\prdouctlog.ldf' , SIZE =
> 1,
> MAXSIZE = 2,FILEGROWTH = 1)
>
> also from the kb article I found that the SQL Server 2000 should give an
> error number 5110 but it is giving an error number 5105 which is the
> number
> for SQL Server 7.0
>
> any idea why it is not working or any tips I can overcome this error?
>
> By the way I am using MS SQL Server 2000 personal edition on Windows XP,
> the
> KB article I found is
> http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
>
> Thanks
> Pradeep


.

Relevant Pages

  • Re: sql 2005 active/passive cluster options
    ... SQL Server MVP ... It just seems to me that using NAS with SQL Server in its current state is ... In a future version, support ... NAS may become robust. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server using BlueArc NAS
    ... > FiberChannel storage connected as NAS. ... They have many customers using SQL ... > for SQL Server storage. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Data Files on NAS Disk Volume.
    ... Lets assume that your NAS is WHQL qualified for argument's sake. ... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ... > One can use Windows Performance/System Monitor to Disk I/O, Queue etc. Can it also be used to get some metrics on NAS Storage? ...
    (microsoft.public.sqlserver.server)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)