October 23, 2012 at 1:44 am
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
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
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.
October 23, 2012 at 9:35 am
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
i actually tested that tool also, it worked.. only tool i got to work
October 23, 2012 at 9:41 am
i will try the new db restart sequense
October 23, 2012 at 11:42 am
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
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?
October 26, 2012 at 9:56 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy