Professional Web Applications Themes

SQL 6.5 Problem - Microsoft SQL / MS SQL Server

I have a client that deleted thier 6.5 DataBase. All I have is a .DAT file. The restore tab is greyed out, not sure why. Is there any way to recover the DB from the .DAT file I have remaining?? I wrote a program to read the .DAT file, but it does not look like a database file. Any assistance in this would be appreciated. It will also be billable to the client to repair. Thanks Gary Liptak...

  1. #1

    Default SQL 6.5 Problem

    I have a client that deleted thier 6.5 DataBase.
    All I have is a .DAT file. The restore tab is greyed out,
    not sure why.
    Is there any way to recover the DB from the .DAT file I
    have remaining??
    I wrote a program to read the .DAT file, but it does not
    look like a database file.
    Any assistance in this would be appreciated. It will also
    be billable to the client to repair.

    Thanks

    Gary Liptak
    Gary Liptak Guest

  2. #2

    Default SQL 6.5 Problem

    Hi Gary.

    You can use DISK REINIT & DISK REFIT to do this with SQL
    6.5. These are doented in the 6.5 Books Online.

    The only problem you might have with these is getting the
    vdev no & device sizes right. Read the doco first & post
    back if you need further clarification / help.

    Regards,
    Greg Linwood
    SQL Server MVP
    >-----Original Message-----
    >I have a client that deleted thier 6.5 DataBase.
    >All I have is a .DAT file. The restore tab is greyed out,
    >not sure why.
    >Is there any way to recover the DB from the .DAT file I
    >have remaining??
    >I wrote a program to read the .DAT file, but it does not
    >look like a database file.
    >Any assistance in this would be appreciated. It will also
    >be billable to the client to repair.
    >
    >Thanks
    >
    >Gary Liptak
    >.
    >
    Greg Linwood Guest

  3. #3

    Default Re: SQL 6.5 Problem

    Hi

    In 6.5 deleting the database does not delete the devices, therefore if the
    devices already exist then you can create the database from them.

    It is not clear if your .dat file is a device or a backup. I don't think you
    can create a new device from an existing file, but you may be able to create
    a device and then overwrite it with your file.

    If the file is a backup then you will have to create devices that are at
    least as big as the original devices (hopefully this was doented!), and
    then restore from the file. At a guess the file is not a backup if you
    restore does not recognise it.

    HTH

    John

    "Gary Liptak" <gliptakiftsolutions> wrote in message
    news:09ae01c33fbc$1c000230$a301280aphx.gbl...
    > I have a client that deleted thier 6.5 DataBase.
    > All I have is a .DAT file. The restore tab is greyed out,
    > not sure why.
    > Is there any way to recover the DB from the .DAT file I
    > have remaining??
    > I wrote a program to read the .DAT file, but it does not
    > look like a database file.
    > Any assistance in this would be appreciated. It will also
    > be billable to the client to repair.
    >
    > Thanks
    >
    > Gary Liptak

    John Bell Guest

Similar Threads

  1. contribute problem - access denied file may not existpermission problem
    By Al1973 in forum Macromedia Contribute Connection Administrtion
    Replies: 6
    Last Post: September 17th, 04:16 PM
  2. Replies: 2
    Last Post: September 30th, 12:13 PM
  3. Replies: 0
    Last Post: August 23rd, 11:56 AM
  4. Replies: 0
    Last Post: August 2nd, 03:03 PM
  5. Replies: 2
    Last Post: July 17th, 07:27 AM

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