Extracting backup ZIP files from the source server

After creating the second SQL Server database instance, complete the following.

Extract ZIP file of backup MAS90 folder

To extract the ZIP file to E:\SourceData

  1. In File Explorer, browse to your Downloads folder.
  2. Copy the ZIP file containing the backup of the MAS90 folder you downloaded from the Azure portal, and paste the ZIP file to E:\SourceData.
  3. Right-click the ZIP file in E:\SourceData and select 7-Zip > Extract Here to unpack the file at E:\SourceData.
  4. Delete the ZIP file.

Extract ZIP file of backup database files

To extract the ZIP file to E:\SourceDB

  1. In File Explorer, browse to your Downloads folder.
  2. Create a temporary folder named DB_Backup_Files, and copy the ZIP file to the folder.
  3. Right-click the ZIP file containing the backup database files in the DB_Backup_Files folder, and select 7-Zip > Extract Here to unpack the files.
  4. Copy the database files to the Backup folder of the second SQL Server database instance you created at: E:\SourceDB\MSSQL16.SOURCEDB\MSSQL\Backup

    Note: If a message appears prompting to allow access to the Backup folder, click Continue.

  5. Delete the ZIP file and temporary DB_Backup_Files folder, and then close File Explorer.

After completing the steps above, see Restoring database backup files.