Unmigrate remote data (Stretch Database)

  • Article

 

Applies To: SQL Server (starting with 2016)

Select Tasks | Stretch | Unmigrate for a table in SQL Server Management Studio to unmigrate the data that Stretch Database has migrated to Microsoft Azure. You can also use Transact-SQL to unmigrate data.

After all the data has been unmigrated, Stretch Database is disabled for the table.

Important info about unmigrating

  • After you start the process to unmigrate your data, you can pause the migration, but you can't cancel it.

  • Unmigrating your data incurs Azure data transfer charges. For more info, see Data Transfers Pricing Details.

Use SQL Server Management Studio to unmigrate data

  1. In SQL Server Management Studio, in Object Explorer, select the table for which you want to unmigrate data.

  2. Right-click and select Tasks, and then select Stretch, and then select Unmigrate.

Use Transact-SQL to unmigrate data

Run the following command.

ALTER TABLE <table name>
    SET ( REMOTE_DATA_ARCHIVE = ON  (MIGRATION_STATE = INBOUND) ) ;
GO;

You can change the migration state of a table from OUTBOUND or PAUSED to INBOUND. After you set the migration state to INBOUND, you can only change it to PAUSED, and then change it back to INBOUND. After all the data is unmigrated, Stretch Database is disabled for the table. After that, if you change your mind, you can enable Stretch Database for the table again and set the migration state to OUTBOUND.

For more info, see ALTER TABLE (Transact-SQL).

See Also

ALTER TABLE (Transact-SQL)
Disable Stretch Database and bring back remote data