SQL Server lets you disconnect a database from the main server program, allowing you to make safe backup copies or send data to branch offices. Once you disconnect a database, you must restore it ...

then you can recover the SQL database from an existing backup using the below steps: First launch ‘SQL Server Management Studio’ (SSMS). Right-click on the Databases and then click Restore Database.