Skip to content

pause-and-resume-data-migration-stretch-database.md

Latest commit

 

History

History
76 lines (56 loc) · 3.1 KB

pause-and-resume-data-migration-stretch-database.md

File metadata and controls

76 lines (56 loc) · 3.1 KB
title Pause and resume data migration (Stretch Database) | Microsoft Docs
ms.custom
ms.date 06/14/2016
ms.prod sql
ms.reviewer
ms.suite sql
ms.tgt_pltfrm
ms.topic conceptual
helpviewer_keywords
Stretch Database, pausing and resuming
pausing Stretch Database
resuming Stretch Database
ms.assetid 65d6a990-b295-41b2-97f9-7b6bf3000e4d
author MikeRayMSFT
ms.author mikeray
manager craigg

Pause and resume data migration (Stretch Database)

[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md-winonly]

To pause or resume data migration to Azure, select Stretch for a table in SQL Server Management Studio, and then select Pause to pause data migration or Resume to resume data migration. You can also use Transact-SQL to pause or resume data migration.

Pause data migration on individual tables when you want to troubleshoot problems on the local server or to maximize the available network bandwidth.

Pause data migration

Use SQL Server Management Studio to pause data migration

  1. In SQL Server Management Studio, in Object Explorer, select the Stretch-enabled table for which you want to pause data migration.

  2. Right-click and select Stretch, and then select Pause.

Use Transact-SQL to pause data migration

Run the following command.

USE <Stretch-enabled database name>;
GO
ALTER TABLE <Stretch-enabled table name>  
    SET ( REMOTE_DATA_ARCHIVE ( MIGRATION_STATE = PAUSED ) ) ;  
GO

Resume data migration

Use SQL Server Management Studio to resume data migration

  1. In SQL Server Management Studio, in Object Explorer, select the Stretch-enabled table for which you want to resume data migration.

  2. Right-click and select Stretch, and then select Resume.

Use Transact-SQL to resume data migration

Run the following command.

USE <Stretch-enabled database name>;
GO
ALTER TABLE <Stretch-enabled table name>   
    SET ( REMOTE_DATA_ARCHIVE ( MIGRATION_STATE = OUTBOUND ) ) ;  
 GO

Check whether migration is active or paused

Use SQL Server Management Studio to check whether migration is active or paused

In SQL Server Management Studio, open Stretch Database Monitor and check the value of the Migration State column. For more info, see Monitor and troubleshoot data migration.

Use Transact-SQL to check whether migration is active or paused

Query the catalog view sys.remote_data_archive_tables and check the value of the is_migration_paused column. For more info, see sys.remote_data_archive_tables.

See Also

ALTER TABLE (Transact-SQL)
Monitor and troubleshoot data migration