Author: snowhite2000 Date: 01-10-24 02:26
Chao_ping
Your Message Box Is Full Again. I didn't catch me, I did it yesterday: Use master database: 1. Use: exec sp_db_detach 'database name', 'True'2. Copy DataFiles and log file to distth, DRIVE3 Useexec 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 02:44
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 Sqlser Vount The Old Databases.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 02:47
Use Step 3 Only, Use master data.
Author: chao_ping
Time: 01-10-24 03:08
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 03:08
I really go to sleep now, bye! Now 3:09 am now,
Author: snowhite2000
Time: 01-10-24 03:10
Have a Nice Dream!
Author: chao_ping
Time: 01-10-24 03:11
Thanks
Author: yanwang
Time: 01-10-24 22:40
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 questionm.