June 3, 2003 at 6:42 am
Any ideas out there? Or am I hosed?
Thanks in advance,
Corey
June 3, 2003 at 6:52 am
Can't remember much about 6.5 but could you not attach the file you have (.dat) to a blank database? You can then backup that BD and restore it onto your proper one.
Cheers,
Crispin
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
June 3, 2003 at 7:02 am
I don't believe that there is any sp_attach_db stored procedure in SQL 6.5.
June 3, 2003 at 11:42 pm
After asking around I was told that you can't attach a DB to a file. Sorry about that 🙂
Did you get it right?
Cheers,
Crispin
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
June 9, 2003 at 9:24 am
I finally figured it out. Here is what I did.
1. Reinstalled SQL Server 6.5 on new machine and applied all service packs. Made sure that I gave the machine the same name as the old machine. Also made sure that I installed on the same drive as the old macine. During install I made sure that the MASTER device was the same size as the MASTER device on the old server.
2. Created all devices and databases that were on the old machine. I made sure that they were all the same size as the devices on the old server and all had the same name.
3. Shut down the SQL Server service.
4. Copied ALL recovered dat files over new dat files (including MASTER and including databases that I did not care about)
5. Re-started SQL Server.
Everything came up fine and I was able to access my old database from the server that had crashed! Thanks for all help on this problem.
Corey
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply