How to Recover A SQL Server Database

zhaozj2021-02-16  83

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.

转载请注明原文地址:https://www.9cbs.com/read-16491.html

New Post(0)