Professional Web Applications Themes

can't attach mdf to sql server - Microsoft SQL / MS SQL Server

Hello, I created a backup copy of an mdf (call it Data.Mdf) file on the server. Now I want to attach that backup mdf so that I can truncate all the tables (shrink the file). But I get the error message in query yzer as follows: Device activation error. The physical file name "C:\Data.LDF" may be incorrect. Could not open new datase "backupData". CREATE DATABASE aborted. Device activation error. The physical file name "C:\Data.LDF" may be incorrect. Does anyone know how I could unlink the backup mdf from the ldf so that I can attach it to the server? Thanks, ...

  1. #1

    Default can't attach mdf to sql server

    Hello,

    I created a backup copy of an mdf (call it Data.Mdf) file
    on the server. Now I want to attach that backup mdf so
    that I can truncate all the tables (shrink the file). But
    I get the error message in query yzer as follows:

    Device activation error. The physical file
    name "C:\Data.LDF" may be incorrect.

    Could not open new datase "backupData". CREATE DATABASE
    aborted.
    Device activation error. The physical file
    name "C:\Data.LDF" may be incorrect.

    Does anyone know how I could unlink the backup mdf from
    the ldf so that I can attach it to the server?

    Thanks,
    Rich
    Rich Guest

  2. #2

    Default Re: can't attach mdf to sql server

    No, but thanks for the suggestion. I'm sure that would be
    a better way to go than the gyrations I have been doing.

    Thanks,
    Rich
    >-----Original Message-----
    >Have you looked at sp_attach_single_file_db?
    >
    >
    >
    >
    >"Rich" <rpng123aol.com> wrote in message
    >news:00b001c33fe7$658de860$a301280aphx.gbl...
    >> Hello,
    >>
    >> I created a backup copy of an mdf (call it Data.Mdf)
    file
    >> on the server. Now I want to attach that backup mdf so
    >> that I can truncate all the tables (shrink the file).
    But
    >> I get the error message in query yzer as follows:
    >>
    >> Device activation error. The physical file
    >> name "C:\Data.LDF" may be incorrect.
    >>
    >> Could not open new datase "backupData". CREATE DATABASE
    >> aborted.
    >> Device activation error. The physical file
    >> name "C:\Data.LDF" may be incorrect.
    >>
    >> Does anyone know how I could unlink the backup mdf from
    >> the ldf so that I can attach it to the server?
    >>
    >> Thanks,
    >> Rich
    >
    >
    >.
    >
    Rich Guest

Similar Threads

  1. Replies: 0
    Last Post: June 19th, 10:51 AM
  2. attach 1 movie, then attach 3 movies to it, help?
    By kie webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 6
    Last Post: January 22nd, 05:09 PM
  3. attach
    By Greg Beaver in forum PHP Development
    Replies: 1
    Last Post: August 4th, 02:31 PM
  4. [PHP] attach
    By Ryan A in forum PHP Development
    Replies: 0
    Last Post: August 4th, 02:03 PM
  5. attach database
    By xixi in forum IBM DB2
    Replies: 0
    Last Post: July 9th, 08:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139