SQL Server Database Restore in Mac M1 Apple Chip Tutorial: Step-by-Step Guide
Вставка
- Опубліковано 19 вер 2024
- You can find SQL installation in Mac M1 using below link. please go through once.
• SQL Server Installatio...
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
docker cp order.bak sql_server:/var/opt/mssql/backup
TYSFMMMMMMM!!!!
it worked perfectly man, thanks!
i dont see the restore button
Bro write ">restore" to up search part
@@spor-music-school5297how?
thanks!!!
The restore button is disabled while restoring the database
have you selected the data base back up file with file type .bak?
I am getting error while restoring database: Restore Database: Microsoft.Data.SqlClient.SqlError: 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.
which SQL server version you have taken the backup?