Last week, a colleague was misused for the database, and I could not return to the state of the day before. The problem of recovering the database has been encountered before DB2, then I think there should be a way to restore the database to the day a day. My machine ERP's database log is from 800m to 2G, and log growth is so fast, and it must be recorded all the operations. After a few days of information, SQL Server Books Online also saw a week, did not find the answer, 9CBS found an article from the log recovery database, the article is unclear as the SQL Server Online. I have asked a few colleagues who have a deep thing in the company. I didn't find the answer. I woke up at 6:30 yesterday morning. I remembered the recovery model in DB2. The recovered database should be the database before recovery, so I get up early. When I came to the office, I experimented once, I thought it would succeed, I didn't expect to recover successfully, very frustrated.
Studying this problem is a week, still has not been solved, and the whole Friday is not good. I remembered Boy, and a newcomer trip to exchange the RD Leader. The result still has no answer, but Boy is very enthusiastic, forwarding this problem to our DBA Running, Running seems to be in Oracle, this recovery in SQL Server is not familiar, but he said: Most of the principles considered.
No, I have to go to Microsoft's official website to find a circle, there is an article that it is best not to use Auto Close, Auto Shrink option, I think it may be the question of these two options. So on Friday afternoon, I tried it once, SQL Query Analyzer is running Restore Database, I haven't responded for a long time, I have to pray that it can restore success, and the result is not as expensive, come out of red error message, saying is data stock Take a conflict, it is originally SQL Server Enterprise Manager is also using the database, so that Enterprise Manager is closed, and the database has been successfully restored, happily jumped. After a few months, I often feel the basic knowledge of theoretical knowledge is not rich enough. Some help documents don't understand, or when you can't run, you often have the theoretical basis. Some problems want to solve the time that it takes a long time, so I will learn the database from the basic theory.
