Restore the SQL Server database from the log

server| Recovery | data | database
Last week, a colleague of mine mistakenly manipulated the database and asked me if I could go back to the previous day's status. The problem of recovering a database has been encountered before when learning DB2, I think SQL Server should also have a way to restore the database to the day before. My machine on the ERP database log from 800M to 2g,log growth so fast, it must be all the operations are recorded. On the internet for a few days of information, SQL Server Books Online also read for one weeks, did not find the answer, CSDN found an article from the log to restore the database and SQL Server online as described above is not clear. Asked a few of the more qualified colleagues in the company, did not find the answer, woke up 6:30 A.M. yesterday, thinking of the recovery model in DB2, the recovery of the database should be in the recovery point before the database, so early up, came to the office, experiment once, thought would be successful, did not think it was not successful recovery, very frustrated.

The study of this problem has been one weeks, still unresolved, the whole week 51 days are bad, think of boy, a newcomer training with us to open the RD leader. There was no answer, but boy was very enthusiastic about forwarding the question to our DBA, running,running, as if it were Oracle, a recovery in SQL Server that was unfamiliar, but he said: more on the principle side.


No, you have to go to Microsoft's official website to find a stroll around, there is an article mentioned, it is best not to use the Auto close,auto shrink option, I think it may be the problem of these two options. So in the afternoon of Friday, and tried again, SQL Query Analyzer running restore database in a long time did not respond, I had to pray to return to success, the result is not as good as people would like to come out of the red error message, said the database access conflict, is the original SQL Server Enterprise Manager is also using the database, so shut down the Enterprise manager, and indeed successfully restored the database, happy to jump up.

Work for several months, often feel that the basic knowledge of the theory is not rich enough, some help documents can not understand, or not run, often because of theoretical basis. Some problems want to solve often take a long time, so later or from the basic theory to learn the database.