Thank you for you viewing this, I have a SQL database in mssql7.0, and I only have a full copy of the /sql7/data forder which was the data file of my former system ,but after I reinstall my Windows 2000 server, then reinstall the sql7,I found I couldn't get the important database back in the data copy .what can I do to restore it?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to restore a badly damaged SQL database?
- Thread starter lumich
- Start date
rajeevnandanmishra
Programmer
Hi lumich,
Try to do following steps.
1) Open the enterprise manager.
2) Create a new databases (with the same name as of your previous databases). Create all of them.
3) Close the enterprise manager
4) Copy your previous data files to the directory where the new data files are stored.
5) Open the enterprise manager.
Close your eyes and remember your god for a moment.
Then try to open the new created databases.
It works a few times for me.
Hope it works for you also.
Try to do following steps.
1) Open the enterprise manager.
2) Create a new databases (with the same name as of your previous databases). Create all of them.
3) Close the enterprise manager
4) Copy your previous data files to the directory where the new data files are stored.
5) Open the enterprise manager.
Close your eyes and remember your god for a moment.
Then try to open the new created databases.
It works a few times for me.
Hope it works for you also.
- Status
Similar threads
- Locked
- Question
