none
Error in database attach Error code:5105

    Question

  • Hi,

        While attaching Database Error throws as below...Pls help me to overcome this.....

       Error in attaching Database in sql 2000

      Error 5105 Device Activation Error ,The physical file name <Path>May be incorrect

    Device activation error ,the physical File name D:\backup\25.01.2010;may be incorrect

    Device activation error ,the physical File name D:\DB\data\DB.NDF ;may be incorrect

    Could not open new database"DB".CREATE DATABASE is aborted.

    Thanks in advance..

    Regards

    Manu


    MANU

    Saturday, August 03, 2013 10:43 AM

Answers

  • what edition of SQL it is?

    http://support.microsoft.com/kb/836873/en-us


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Monday, August 05, 2013 7:25 AM

All replies

  • Where are you getting the error message and is this the exact message?  Are you sure that the file names and paths are all correct?  Most of these errors are a result of a typo in your path/file syntax.  Ex: Is "<Path>" defined?  The first path supplied in D:\backup\... does not have a file name attached.  Can you verify the paths/file names?

    Thanks,
    Sam Lester (MSFT)


    http://blogs.msdn.com/b/samlester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Saturday, August 03, 2013 11:01 AM
    Moderator
  • While selecting a MDf file it automatically listing the files like NDF, LDF where MDF LDF files are ok and other file was throwing a error as like

    Device activation error ,the physical File name D:\DB\data\DB.NDF ;may be incorrect

    Regards

    Manu


    MANU

    Saturday, August 03, 2013 11:15 AM
  • Does the D:\DB\data\ path exist?

    Thanks,
    Sam Lester (MSFT)


    http://blogs.msdn.com/b/samlester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Saturday, August 03, 2013 11:19 AM
    Moderator
  • Dear Sam Lester,

       We are using application developed in VB and the backend is Sql 2000

       Due to Application  corruption we are pushed to reinstalled the application .while installing app it automatically creates a DB files in the path of D:\DB\data\DB.mdf and D:\DB\data\Db.ldf ,so we detached the new Db and renamed the new MDF and LDF files and copeid the old MDF LDF files in the same folder while attaching this files it throws a error as 

     Error 5105 Device Activation Error ,The physical file name <Path>May be incorrect

    Device activation error ,the physical File name D:\backup\25.01.2010;may be incorrect

    Device activation error ,the physical File name D:\DB\data\DB.NDF ;may be incorrect

    Could not open new database"DB".CREATE DATABASE is aborted.

    Regards

    Manu


    MANU

    Saturday, August 03, 2013 11:28 AM
  • "D:\backup\25.01.2010;" is not a valid filename, it contains characters which aren't allowed in a filename. Can you post the command you are executing? You can script it in SSMS.

    Tibor Karaszi, SQL Server MVP | web | blog


    Saturday, August 03, 2013 4:11 PM
    Moderator

  • MANU

    Monday, August 05, 2013 5:21 AM
  • what edition of SQL it is?

    http://support.microsoft.com/kb/836873/en-us


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Monday, August 05, 2013 7:25 AM
  • We are using application developed in VB and the backend is Sql 2000

    Hello Manu,

    And which SQL Server version are you using for develoing? If you may use Visual Studio 2008/2010/2012 Visual Basic for developing, then I guess you used the SQL Server Express Edition, which comes along with VS and thats SQL Server version 2005 or higher; you can't restore a backup of a newer SQL Server version to an older one; that would explain the error message.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, August 05, 2013 7:47 AM
    Moderator
  • Go through below link it may helps you

    http://support.microsoft.com/kb/836873/en-us

    Monday, August 05, 2013 8:11 AM
  • Here is what I think is happening:

    That database you try to attach had several database files. Not only the ones you list in the CREATE DATABASE ... command, but also the ones listed in the error message that you are seeing. Why that is and how that happened, I can of course not answer. Nor can I answer why whoever added the files decided on those strange filenames. But that is what the error message suggests.

    So if the database is still available on the source server, I suggest you go there and verify if this is the case. I.e., try to find all the files that the database was using and specify all those files (as suggested by the error message) on the CREATE DATABASE ... FOR ATTACH command.


    Tibor Karaszi, SQL Server MVP | web | blog

    Monday, August 05, 2013 9:15 AM
    Moderator