November 5, 2001 at 6:41 am
Hi,
We had a crash of a disk which hosted the NT4 server OS and the SQL Server 6.5 core files. Hopefully, the data files, including the master.dat file, were on another disk. Now the bad news are : we do not have any backups of the system disk, so we reinstalled NT4, we recreated the shares and as the server was not a PDC, users have access to their files on the data disk. Regarding the SQL Server, I'm planning to reinstall it and specify the location of the data files if prompted. But will it work ? Do people have experience with such a recovery ?
Thanks in advance
November 5, 2001 at 1:16 pm
Whew, not sure if you can get the db without the log.
I think you need to recreate the database with a blank file (using the GUI). Then shutdown the server and replace the blank file with your backup file.
I would recommend, however, that you install SQL Server 2000 and attach this database file and run in v6.5 mode. Not sure if this will work either.
You may need to contact MS for this one. This is probably highly worth the $250.
Steve Jones
November 6, 2001 at 3:09 am
Hi Thanks for your advise. Unfortunately it did not work but I realised that I had daily backup files of all the critical dbs, master, logs, etc. So I reinstalled a fresh SQL Server 6.5, I went to the admin too and restored the data from the file backups. We will lose some hours of work but as this database is only used for monitoring the badge accesses to the office, it is not critical but we'll need to review the disaster recovery procedures for our production databases ...
April 10, 2008 at 7:30 am
Hi, plimon!
I am having the same problem. I've got this 4 GB .DAT file from the SQL Server 6.5 of our client. I wanna restore it back to a newly installed SQL Server 6.5 on my workstation. What are the procedures in the restoring the .DAT file in 6.5? Thanks.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply