Disabling Stretch Database for tables using Transact-SQL

You can use Transact-SQL to perform the same action. The following code example instructs SQL Server to disable Stretch DB for the stretch table T1 but to transfer the already-migrated data for the table to the local database first:

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

If you don't need the already-migrated data (or you want to avoid data transfer costs), use the following code:

USE Mila; 
ALTER TABLE dbo.T1 SET (REMOTE_DATA_ARCHIVE = OFF_WITHOUT_DATA_RECOVERY (MIGRATION_STATE = PAUSED));  
..................Content has been hidden....................

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