Solved

Error Message 5105

Posted on 2000-03-24
1
255 Views
Last Modified: 2008-02-01
We are using sp_attach_db to import a .mdf and  .ldf file to MS SQL Server 7.0. We received the message "Device activation error. The physical file name '*.mdf' may be incorrect". Has anyone encountered this problem before or know of its solution
0
Comment
Question by:danetteh
1 Comment
 
LVL 4

Accepted Solution

by:
Gustavo Perez Buenrostro earned 50 total points
ID: 2655404
danetteh,

Remember that MS-SQL doesn’t support the access of database devices over the network.

For more information, read the article titled “INF: Support for Network Database Files” at:

http://support.microsoft.com/support/kb/articles/Q196/9/04.ASP?LNG=CAN&SA=&FR=1
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question