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?
SQL Server Backup – Restore Linux Backup on Windows
backuplinuxrestoresql serversql-server-2017
Related Question
- How to Restore SQL Server 2012 Standard Backup to Web Edition
- SQL Server for Linux – Backup to the Null Device
- SQL Server Migration – Moving a SQL Server DB from Windows to Linux Fails
- Sql-server – sql server – Restoring Windows Database Backup File on a Linux Server Instance
- Sql-server – SQLServer Linux: Error restoring backup of DB from Windows w/ full-text data file
- Sql-server – SQLServer Linux: Restore full database / Catalog
- Sql-server – How to access ETW Traces on SQL Server for linux
- SQL Server – Moving Database Between SQL Server 2016 and 2017
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.