Hundreds of thousands of rush! SQL database backup and restore!

yshysh1102

I do it like this
 
Database >> All Tasks >> Additional Database

But I only have a .bak backup file. How can I restore this backup?

cv4bf5d65fd

Not attached database
You should choose to restore the database

yshysh1102

However, if you use Restore Database, there is no data file selected. I haven't found where to find the .bak file to restore for a long time. I haven't done SQL and used it urgently. The big brother upstairs can help me, thanks

10118419

Choose to restore the database. Then remember to change the database path

恶魔右指

Restore the database, just change the database

yshysh1102

Failed to gain exclusive access to the database because the database is in use,

yshysh1102

I just rushed and I didn't finish the reply

Failed to gain exclusive access to the database because the database is in use,
RESTORE DATABASE operation terminal exception

What means?

lbeast001

Restore database, options from device

imapiggy

.bak file is used to restore the database
.mdf file is used to attach the database

unkmass

First create a new database with the same name, and then restore it.