SQL Server detaches the attached backup database

Task → detach → Make sure you can find the detached database C:\Program Files\Microsoft SQL Server\mssql11 in this location. Mssqlserver\mssql\data

Execute the following SQL

Use [master]
GO
EXEC master.dbo.sp_detach_db @dbname = N ' Qsdb '
GO

********************************************************

tasks → Extras →

Use [master]
GO
CREATE DATABASE [Qsdb] On
(FILENAME = N ' C:\Program Files\Microsoft SQL Server\mssql11.) Mssqlserver\mssql\data\qsdb.mdf '),
(FILENAME = N ' C:\Program Files\Microsoft SQL Server\mssql11.) Mssqlserver\mssql\data\qsdb_log.ldf ')
For ATTACH
GO

exec sp_attach_db Qsdb, ' C:\Program Files\Microsoft SQL Server\mssql11. Mssqlserver\mssql\data\qsdb.mdf ', ' C:\Program Files\Microsoft SQL Server\mssql11. Mssqlserver\mssql\data\qsdb_log.ldf '

********************

Backup restore

High-version Database

tasks → backup → address

Task → restore → database → device → address

SQL Server detaches the attached backup database