Restore method:
Please be on the new server,
In the Database Enterprise Manager,
Choose security,
Create a database user named FreeHost,
(The password must be the same as the password on the original server)
Create a database called FreeHost.
Then use the enterprise manager of the database.
Restore the BAK file to the FreeHost database
Finally, run the "Query Analyzer" in the Enterprise Manager
Execute the following command:
use freehost
exec sp_change_users_login 'Auto_Fix','freehost'
The restoration work was completed.
Please be on the new server,
In the Database Enterprise Manager,
Choose security,
Create a database user named FreeHost,
(The password must be the same as the password on the original server)
Create a database called FreeHost.
Then use the enterprise manager of the database.
Restore the BAK file to the FreeHost database
Finally, run the "Query Analyzer" in the Enterprise Manager
Execute the following command:
use freehost
exec sp_change_users_login 'Auto_Fix','freehost'
The restoration work was completed.