SQL Server Database Restore in Mac M1 Apple Chip Tutorial: Step-by-Step Guide

You can find SQL installation in Mac M1 using below link. please go through once.

SQL Server Installation on Mac Apple Chip: Step-by-Step Tutorial for Beginners

Welcome to our comprehensive SQL Server Database Restore tutorial! In this video, we'll take you through the process of restoring a SQL Server database. Whether you're a database administrator or a developer, mastering database restoration is crucial for data recovery and maintenance.

In this tutorial, we are covering step-by-step demonstration of restoring a SQL Server database using SQL in Mac machine.

Whether you're new to SQL Server or looking to enhance your skills, this tutorial will provide you with the knowledge and confidence to handle database restoration effectively. Don't forget to like, share, and subscribe for more SQL Server tutorials and database management tips!

Step 1: Locate folder path where .bak file is stored

cd downloads

Step 2: To create new directory in container

docker exec -it sql_server mkdir /var/opt/mssql/backup

Step 3 Copy files from Mac to container

[suryatayi]

The restore button is disabled while restoring the database

[lekhrajawasthi]

I am getting error while restoring database: Restore Database: The database was backed up on a server running database version 957. That version is incompatible with this server, which supports version 931. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.