SQL Server backup problem records when restoring data

1. Final Solution about "cannot get exclusive access to the database because the database is in use"

Key SQL statements:

ALTER DATABASE [datebase] SET OFFLINE with ROLLBACK IMMEDIATE

Run out and then

ALTER DATABASE [dbname] set online

PS. Resolve this issue by making the database ' offline '

2. When restoring a database, the error message is: cannot overwrite Xx/xx.mdf

Click on the top left corner of the selection page, select the ' file ' option and rename the ' revert to ' target file to resolve this issue

SQL Server backup problem records when restoring data