Results 1 to 5 of 5

Thread: SQL server 6.5

  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Red face Unanswered: SQL server 6.5

    Hi

    I have a problem with my SQL server 6.5 the computer doesn't work. I only have the original files (*.dat) not Backups.

    I can load a .Dat file on another computer running SQL server 6.5?

    How?

    Please Help Me...


    ORJ

  2. #2
    Join Date
    May 2003
    Posts
    60
    After a little digging I came across another post, this is what I found.

    Nedim,

    Q. How can I recover a SQL Server database when all I have left is the original
    .DAT devices or files?

    R. For SQL 7.0 use the sp_attach_db stored procedure - documented in Books Online.

    For SQL 6.5 and below use the DISK REINIT and DISK REFIT commands. These are also
    documented in Books Online.

    An alternative for SQL 6.5 is :-
    . Stop SQL Server
    . Backup/copy the original .dat files on the target server, if any.
    . Start SQL Server.
    . Drop any databases and devices you want to recover, and delete the associated
    physical files.
    . Create new devices/databases the right size, with the right names and in the
    right order.
    . Stop SQL Server.
    . Copy the original .dat files over the newly re-created ones.
    . Start SQL Server.


    Hope this helps

  3. #3
    Join Date
    Oct 2003
    Posts
    2

    Red face SQL server 6.5

    I do that but everything is OK until I replace the file that cause that the database don't respond, appear a "Suspect" Database can't be edited.

    Please Help me...


    ORJ

  4. #4
    Join Date
    May 2003
    Posts
    60
    I think it's looking for the device file that the .dat was attached too. You could try creating a new device file but I'm not sure how to do that.

    Try looking here:
    http://support.microsoft.com/default...NoWebContent=1

    It's a start.

  5. #5
    Join Date
    Oct 2003
    Posts
    1

    Re: SQL server 6.5

    Originally posted by orosario
    Hi

    I have a problem with my SQL server 6.5 the computer doesn't work. I only have the original files (*.dat) not Backups.

    I can load a .Dat file on another computer running SQL server 6.5?

    How?

    Please Help Me...


    ORJ
    In 6.5, if you have only the .dat files and need to recover, I believe you want to use the DISK REINIT command. There is a post on DBforums about this. See http://dbforums.com/arch/176/2003/4/759116

Posting Permissions

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