Post reply

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

  • October 23, 2012 at 1:44 am

    #284026

    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.

  • October 23, 2012 at 4:18 am

    This was removed by the editor as SPAM

  • October 23, 2012 at 6:05 am

    #1551853

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

  • October 23, 2012 at 9:17 am

    #1551976

    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

  • October 23, 2012 at 9:35 am

    #1551984

    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

  • October 23, 2012 at 9:40 am

    #1551985

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

  • October 23, 2012 at 9:41 am

    #1551986

    i will try the new db restart sequense

  • October 23, 2012 at 11:42 am

    #1552022

    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.

  • October 26, 2012 at 3:13 am

    This was removed by the editor as SPAM

  • October 26, 2012 at 9:31 am

    #1553253

    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

  • October 26, 2012 at 9:56 am

    #1553275

    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.

  • September 17, 2014 at 7:29 am

    #1746055

    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 12 posts - 1 through 11 (of 11 total)

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