How to recover a SQL Server database

Author:Snowhite2000 Time:01-10-24

Chao_ping

Your message box is full again.

You really caught me. I did it yesterday:

Use master database:

1. Use:

Exec sp_db_detach 'database name', 'true'

2. Copy datafiles and log file to Dist. Drive

3. Use

Exec sp_attach_db @ dbname = n' database name ',
@ Filename1 = n' New Path. MDF ',
@ Filename2 = n' New Path. ldf'

Send me a message, if you have problems.

Author:Chao_ping Time:01-10-24

And if I have reinstalled the SQL server,
And the new installed master database does not contain the information about my another database, and I only have the old datafiles and logfiles,
How to add this database into the sqlserver?

Your method just moves datafile allocation, and what I want to do is:
After a clean installation, let the new sqlserver mount the old databasees.

Just like in Oracle, I removes Oracle software, reinstall it,
And use Oracle to mount the old database.
Thanks.

Author:Snowhite2000 Time:01-10-24

Use step 3 only, use master databasde.

Author:Chao_ping Time:01-10-24

Seems Faily easy,
Made it.
Thanks so much.
In fact such easy a job, I donot know it, faint.
Thanks again.

Author:Chao_ping Time:01-10-24

I really go to sleep now, bye!
Now :09 am now,

Author:Snowhite2000 Time:01-10-24

Have a nice dream!

Author:Chao_ping Time:01-10-24

Thanks

Author:Yanwang Time:01-10-24

Chao_ping,

I saw a message from you that asked me to check mailbox. I tried, but I can not login to it. maybe I typed wrong username and password. sorry about it. I guess it's about SQL Server, it looks that you solved the problem.