Here’s how: Open SQL Server Management Studio (SSMS). In the Object Explorer, right-click the Databases node and select Restore Database. Select the appropriate options and press OK to restore the ...