Restore is always prompt after database restore

Problem: Restoring after database restore is always prompt

650) this.width=650; "title=" 666.jpg "src=" https://s1.51cto.com/wyfs02/M02/9D/EA/ Wkiol1miawrh5cdxaadxr2jcck0558.jpg "alt=" Wkiol1miawrh5cdxaadxr2jcck0558.jpg "/>

Workaround:

Execute in new query: Restore Database School educational system with recovery script, and then refresh databases can be empty single to the database node the contents of the school administration system.

Restore database Datebasename with recovery where databasename is the data name being restored

650) this.width=650; "Width=" "height=" 370 "title=" 777.jpg "style=" width:700px;height:370px; "src=" https:// S1.51cto.com/wyfs02/m01/9d/ea/wkiol1mibg2jwkgnaah02smwmia429.jpg "border=" 0 "vspace=" 0 "hspace=" 0 "alt=" Wkiol1mibg2jwkgnaah02smwmia429.jpg "/>

When the database is refreshed, the node information appears, and the restore state disappears.

650) this.width=650; "Width=" "height=" 452 "title=" 888.jpg "style=" width:700px;height:452px; "src=" https:// S5.51cto.com/wyfs02/m02/9d/ea/wkiol1mibmixeb8taaieuimvr1i629.jpg "border=" 0 "vspace=" 0 "hspace=" 0 "alt=" Wkiol1mibmixeb8taaieuimvr1i629.jpg "/>

If one database is backed up to another computer or server, it is recommended that you restore the database. Do not use the new database, and then restore the database. Because a new database restore typically causes an error: The database character set is inconsistent with the original database.

This article is from the "Sandshell" blog, make sure to keep this source http://sandshell.blog.51cto.com/9055959/1954310

Restore is always prompt after database restore