how to recover a sql database

[lumich]

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?

 

[tlbroadbent]

I'm unclear what you mean? You say,

"I only have a full copy of the /sql7/data forder which was the data file of my former system..."

I assume you mean that you have a backup copy of the SQL Data folder which contained all of the MDF and perhaps the LDF files. Is this assumption correct?

Or do you have a backup folder that contains database backup (i.e., .BAK, .DIF and/or .TRN) files?

You also say,
"I found I couldn't get the important database back in the data copy..."

This is the part that is very confusing. Do you mean that the MDF file doesn't exist or can't be restored to the server? Or do you mean that although the file exists in the folder, the database doesn't show in SQL Server?

Were you able to recover other databases besides the one in question? In particular, did you recover the master datasbase? When you reinstalled SQL server the master was rebuilt so all your databses would no longer exist in SQL server. Hopefully, you've been able to recover master.

Do you get any error messages? What have you tried so far?

I really don't know which if any of my questions are pertinent to the problem. Please forgive me if I've asked unnecssary questions. I'm just trying to understand the nature of the problem. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[istblj]

Hi all,
I'm having a major problem with one of my SQL databases and am in desparate need of help. I have SQL 7 installed and when I checked the database on Monday it read (recover/suspect.) It was 1st recommended I leave the database to recover and complete whatever transactions it was processing. On Wednesday I decided to reset the database and execute the follwing qurey: sp_resetstatus "databse name."

That process didn't work so I tried running"
USE Master
Go
sp_configure "allow updates', 1
Go
Reconfigure with override
Go

That process didn't work either so I tried to drop the database and recreate it. That appeared to work, but when I try to create a new database with the same name it states the database already exists, but the database name is not listed under databases. What do I do next?

 

[tlbroadbent]

istblj,

Please post your question as a new thread so it will get the attention it needs. Adding new questions to old threads will generally result in the question being ignored.

Thanks, Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin