How to Restore a .bak File using SQL Operations Studio (SQLOPS)

• SQL Server on Mac
• Copy file from Host to Docker

Step by step tutorial for restoring a SQL Server .bak file using SQL Operations Studio.

SQL Operations Studio (SQLOPS) enables us to restore a database by pointing and clicking our way through the dialog boxes. It works just like restoring a database using SQL Server Management Studio.

Below are step by step instructions for restoring a database using SQLOPS. This assumes that SQL Server is running and you're connected to it via SQL Operations Studio.

1. Initiate the Restore Process

   Click the Restore button on the Server Dashboard.

   

2. Select the Source

   Select Backup file from the first dropdown menu.

   Then click the ellipsis (...) to open the file explorer.

   

3. Select the .bak File

   Navigate to the .bak file, select it, then click OK.

   

4. Restore

   Click Restore to start the restore.

   

5. Wait...

   Watch the Task History bar for the restore to complete. Should only take a minute or two.

   

6. Finished - View the Database

   Once the restore is complete, click the Servers icon at the top left of the SQLOPS interface. Your new database should appear in the list of databases (you might need to refresh the list by right-clicking on Databases and selecting Refresh).

   

7. Check the Database

   Run a quick test. For example, right-click on a table and select Select Top 1000.

   Do any other tests as required.

   

• SQL Server on Mac
• Copy file from Host to Docker