SQL Server Backup – Restore Linux Backup on Windows

backuplinuxrestoresql serversql-server-2017

I am running SQL Server in docker on a mac. I have taken a SQL Server backup from windows and restored it in the mac SQL Server docker instance. Now I want to take a backup from the SQL Server docker instance and restore it back to windows. When I attempt to restore on Windows I am getting a "System tables sysfiles1 is corrupted".
Is it possible to take a back up from SQL Server Linux and restore it on SQL Server Windows?

Best Answer

I just validated it. Yes. Not only is it possible, other than using the WITH MOVE to change where the files are located, there's literally nothing special involved. I tested it using a shared volume to get the backup out of my docker instance. I also tested it using the docker file copy command. Both worked just fine. It's possible that the backup is corrupt or that the versions are off.