Pause and resume data migration

To pause data migration for a table, choose the table in SSMS and then select the option Stretch | Pause. You can achieve the same with the following Transact-SQL command; it temporarily breaks the data migration for the T1 table:

USE Mila; 
ALTER TABLE dbo.T1 SET (REMOTE_DATA_ARCHIVE (MIGRATION_STATE = PAUSED));   

To resume data migration for a table, choose the table in SSMS and then select the Stretch/Resume option or write the Transact-SQL code, similar to the following one:

USE Mila; 
ALTER TABLE dbo.T1 SET (REMOTE_DATA_ARCHIVE (MIGRATION_STATE = OUTBOUND));   

To check whether migration is active or paused, you can open Stretch Database Monitor in SQL Server Management Studio and check the value of the Migration State or column check the value of the flag is_migration_paused in the system catalog view sys.remote_data_archive_tables.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.15.226.120