Need to help to Restore/attach a database in SQL 6.5

  • pelsebubb

    Say Hey Kid

    Points: 661

    I have the data.Dat and log.dat files, but i find it hard to actually attach it or restore it into sql 6.5.

    Tried with Stored procedure 'sp_attach_db', but that is not found on the server.

    Can anyone help me with the sql query to attach DB to this server version.

  • pelsebubb

    Say Hey Kid

    Points: 661

    Im using trusted connection with sa user, i also verified that that SP is not in the master db.

  • David Webb-CDS

    SSCoach

    Points: 17338

    Is this actually a SQL Server 6.5 database? If it is, you might try creating a database with the same file names, shutting down the server, replacing the created files with your existing files and re-starting the server. Make copies of the files before you do this, just in case.


    And then again, I might be wrong ...
    David Webb

  • SQLRNNR

    SSC Guru

    Points: 281079

    Here is a tool that others have had work

    http://www.officerecovery.com/mssql/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • pelsebubb

    Say Hey Kid

    Points: 661

    i actually tested that tool also, it worked.. only tool i got to work

  • pelsebubb

    Say Hey Kid

    Points: 661

    i will try the new db restart sequense

  • pelsebubb

    Say Hey Kid

    Points: 661

    pelsebubb (10/23/2012)


    i will try the new db restart sequense

    Tried this with no success, the DB popped up in suspect mode, and i could not reset it with emergency mode, guess i have to buy that damn software then.

  • David Webb-CDS

    SSCoach

    Points: 17338

    Were these files copied from a SQL Server that was running when the files were copied? If so, they may not be in a state that will allow them to be attached. That may be why the database went suspect when you did the copy-and-restart sequence.

    Is there any way you can get a backup of this database rather than trying to use the raw files?


    And then again, I might be wrong ...
    David Webb

  • pelsebubb

    Say Hey Kid

    Points: 661

    David Webb-200187 (10/26/2012)


    Were these files copied from a SQL Server that was running when the files were copied? If so, they may not be in a state that will allow them to be attached. That may be why the database went suspect when you did the copy-and-restart sequence.

    Is there any way you can get a backup of this database rather than trying to use the raw files?

    Okey. Only got those files i managed to export all to SQL format with the program i bought.

  • schleep

    SSChampion

    Points: 12506

    If memory serves -- and it's been a loooong time -- the detach-attach functionality only arrived with SQL 7.

    So you're stuck with Restore Database.

    First, create an new, empty db.

    I think this is the 6.5 syntax:

    RESTORE DATABASE <newDB>

    FROM DISK="<backup file path>"

    WITH REPLACE

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply