Enable Database for Stretch – Part 1

Create Azure Database , user name and password.Configure the Firewall Rules (Local IP address) to connect to Azure.

image

image

image

Oct 11 2015 17:21:30: Log opened. TraceLevel:Informational

Oct 11 2015 17:21:32 [Informational] UI Authentication via ADAL:CommonAzureUserAuthenticationUIControl Message:Session expired. 

Oct 11 2015 17:21:33 [Informational] UI Authentication via ADAL:CommonAzureUserAuthenticationUIControl Message:Token Cache cleared; Going to sign in screen. 

Oct 11 2015 17:22:25 [Informational] UI Authentication via ADAL:CommonAzureUserAuthenticationUIControl Message:User logged in as dbprox@outlook.com and subscription 02ae5e45-64be-4858-b2e8-cc22cfc414e0. 

Oct 11 2015 17:24:38 [Informational] Task:cde6ec64-3935-41c4-98ca-bb97d11cd15a:StretchValidationTask: Running: 0%: None: Validating Source SQL Database started. 

Oct 11 2015 17:24:38 [Informational] Task:cde6ec64-3935-41c4-98ca-bb97d11cd15a:StretchValidationTask: Running: 0%: None: StretchValidationTask Started. Retry = 1. 

Oct 11 2015 17:24:38 [Informational] Task:cde6ec64-3935-41c4-98ca-bb97d11cd15a:StretchValidationTask: Stopped: 100%: Successful: Task processing completed. 

Oct 11 2015 17:24:43 [Informational] Task:e0bc4758-90d9-45f7-820f-59eb497369c1:StretchAzureProvisioningTask: Running: 0%: None: Provisioning Azure SQL Database Server started. 

Oct 11 2015 17:24:43 [Informational] Task:e0bc4758-90d9-45f7-820f-59eb497369c1:StretchAzureProvisioningTask: Running: 0%: None: StretchAzureProvisioningTask Started. Retry = 1. 

Oct 11 2015 17:24:43 [Informational] Task:e0bc4758-90d9-45f7-820f-59eb497369c1:StretchAzureProvisioningTask: Running: 0%: None: Provisioning Azure SQL Database Server : Found resource group 'Default-SQL-SoutheastAsia'. 

Oct 11 2015 17:25:29 [Informational] Task:e0bc4758-90d9-45f7-820f-59eb497369c1:StretchAzureProvisioningTask: Stopped: 100%: Successful: Provisioning Azure SQL Database Server 'remotedataarchive-lenovo-pc-sql201-sql2016db-20151011-172130496.database.windows.net' completed. 

Oct 11 2015 17:25:29 [Informational] Task:e0bc4758-90d9-45f7-820f-59eb497369c1:StretchAzureProvisioningTask: Stopped: 100%: Successful: Task processing completed. 

Oct 11 2015 17:25:33 [Informational] Task:dc90be34-799e-49e1-81ac-e6c74048a57e:StretchAzureConfigurationTask: Running: 0%: None: Configuring Azure SQL Database Server Firewall Rule started. 

Oct 11 2015 17:25:33 [Informational] Task:dc90be34-799e-49e1-81ac-e6c74048a57e:StretchAzureConfigurationTask: Running: 0%: None: StretchAzureConfigurationTask Started. Retry = 1. 

Oct 11 2015 17:25:33 [Informational] Task:dc90be34-799e-49e1-81ac-e6c74048a57e:StretchAzureConfigurationTask: Running: 0%: None: Created remote server credential on via 'CREATE CREDENTIAL [remotedataarchive-lenovo-pc-sql201-sql2016db-20151011-172130496.database.windows.net] WITH IDENTITY = 'dbprox', SECRET = '********''. 

Oct 11 2015 17:25:34 [Informational] Task:dc90be34-799e-49e1-81ac-e6c74048a57e:StretchAzureConfigurationTask: Running: 0%: None: Auto-detecting SQL Database Engine Client IP Address completed. Found: '116.88.15.7'. 

Oct 11 2015 17:25:36 [Informational] Task:dc90be34-799e-49e1-81ac-e6c74048a57e:StretchAzureConfigurationTask: Stopped: 100%: Successful: Configuring Azure SQL Database Server Firewall rule with Start IP '116.88.15.7' and End IP '116.88.15.7' on 'remotedataarchive-lenovo-pc-sql201-sql2016db-20151011-172130496.database.windows.net' completed. 

Oct 11 2015 17:25:36 [Informational] Task:dc90be34-799e-49e1-81ac-e6c74048a57e:StretchAzureConfigurationTask: Stopped: 100%: Successful: Task processing completed. 

Oct 11 2015 17:25:38 [Informational] Task:b5054528-8c97-4ca0-9ce8-16b5063d9d50:StretchSourceDatabaseConfigurationTask: Running: 0%: None: Configuring Source SQL Database started. 

Oct 11 2015 17:25:38 [Informational] Task:b5054528-8c97-4ca0-9ce8-16b5063d9d50:StretchSourceDatabaseConfigurationTask: Running: 0%: None: StretchSourceDatabaseConfigurationTask Started. Retry = 1. 

Oct 11 2015 17:26:41 [Informational] Task:b5054528-8c97-4ca0-9ce8-16b5063d9d50:StretchSourceDatabaseConfigurationTask: Stopped: 100%: Successful: Enable Stretch on 'SQL2016DB' to Azure SQL Database Server 'remotedataarchive-lenovo-pc-sql201-sql2016db-20151011-172130496.database.windows.net' via 'ALTER DATABASE [SQL2016DB] SET REMOTE_DATA_ARCHIVE = ON (SERVER = N'remotedataarchive-lenovo-pc-sql201-sql2016db-20151011-172130496.database.windows.net')' completed 

Oct 11 2015 17:26:41 [Informational] Job:1281350b-cd56-4535-88f5-2eb2b0b4f52f: Stopped: Enable Stretch on 'SQL2016DB' to Azure SQL Database Server 'remotedataarchive-lenovo-pc-sql201-sql2016db-20151011-172130496.database.windows.net' via 'ALTER DATABASE [SQL2016DB] SET REMOTE_DATA_ARCHIVE = ON (SERVER = N'remotedataarchive-lenovo-pc-sql201-sql2016db-20151011-172130496.database.windows.net')' completed: Successful Oct 11 2015 17:26:41 [Informational] Task:b5054528-8c97-4ca0-9ce8-16b5063d9d50:StretchSourceDatabaseConfigurationTask: Stopped: 100%: Successful: Task processing completed. 

Oct 11 2015 17:26:41 [Informational] Job:1281350b-cd56-4535-88f5-2eb2b0b4f52f: Stopped: Task processing completed.: Successful Oct 11 2015 17:26:41 [Informational] Log Closed:1281350b-cd56-4535-88f5-2eb2b0b4f52f Message:Job processing completed. 

Leave a Reply

Your email address will not be published. Required fields are marked *