Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what to do after sqlserver backup can not be restored". In the daily operation, I believe that many people have doubts about how to restore after sqlserver backup. The editor consulted all kinds of data and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubt of "how to restore after sqlserver backup". Next, please follow the editor to study!

The project is not finished in the company, take it back to do, after the project is fully backed up, take it back, build a new one at home, in the restore, say inconsistent, tangled

Before this kind of situation also appeared, all is after the separation, examines the database file directly, but today did not take the test, Baidu once, found the relevant solution, shared, casually recorded

After it has been solved, the same problem will arise and then look for it.

The first one is to set up a database in any specified directory. In order to facilitate me to set up the database under the d disk data folder, the backup data can be moved to the specified database by doing the following

RESTORE DATABASE test

FROM DISK ='D:\ test.bak' with replace

MOVE 'test' TO'd:\ Data\ test.mdf'

MOVE 'test_log' TO'd:\ Data\ test_log.ldf'

If you back up multiple times, it seems that the earliest version is restored by this method, don't worry, you can restore it again and choose the latest one!

At this point, the study on "what to do after sqlserver backup cannot be restored" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.