Enable, Disable Stretch Database

ByDr. SubraMANI Paramasivam

Enable, Disable Stretch Database

You can now easily enable & disable stretch database both in GUI via SSMS and also using T-SQL. Below screens provides you on each step involved in enabling the Stretch for the database.

Enable_StretchDB

Enable_StretchDB02 Enable_StretchDB03 Enable_StretchDB04 Enable_StretchDB05 Enable_StretchDB06 Enable_StretchDB07 Enable_StretchDB08 Enable_StretchDB09

You can easily disable stretched database using below T-SQL.

ALTER DATABASE DAGEOP_STRETCH2
SET REMOTE_DATA_ARCHIVE = OFF

About the Author

Dr. SubraMANI Paramasivam administrator

Dr.SubraMANI Paramasivam is a Data Platform MVP, Power BI Group Leader, International Speaker, Microsoft Certified Trainer and Principal Solutions Architect at DAGEOP Ltd, having 20+ years of DB, BI & Analytics experience. Dr.SubraMANI Paramasivam is a frequent speaker in SQLBITS, PASS Summit, PASS SQL Saturdays, SQLRelay, Data Platform Summit, MCT Summit, SQLServerGeeks Summit, INSIDESQL UK, Data Awareness Programmes, Data Day Events. He likes to enlighten the education & data and started his own journey with FREE Data Awareness Programme (www.dataap.org), in remote areas who are in need. Mani speaks a lot about Visualization, Data Science, R Analytics, Azure concepts, Performance Tuning, DB & SQL Server Architecture, DBA, Partitioning, Resource Governor, Disaster Recovery, High Availability, Development, T-SQL Programming and Microsoft certifications.

Comments Are Closed!!!