Relational Database ServiceRelational Database Service

Compute
Elastic Cloud Server
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
Domain Name Service
VPC Endpoint
Cloud Connect
Enterprise Switch
Security & Compliance
Anti-DDoS
Web Application Firewall
Host Security Service
Data Encryption Workshop
Database Security Service
Advanced Anti-DDoS
Data Security Center
Container Guard Service
Situation Awareness
Managed Threat Detection
Compass
Cloud Certificate Manager
Anti-DDoS Service
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GaussDB NoSQL
GaussDB(for MySQL)
Distributed Database Middleware
GaussDB(for openGauss)
Developer Services
ServiceStage
Distributed Cache Service
Simple Message Notification
Application Performance Management
Application Operations Management
Blockchain
API Gateway
Cloud Performance Test Service
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
DevCloud
ProjectMan
CodeHub
CloudRelease
CloudPipeline
CloudBuild
CloudDeploy
Cloud Communications
Message & SMS
Cloud Ecosystem
Marketplace
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP License Service
Support Plans
Customer Operation Capabilities
Partner Support Plans
Professional Services
enterprise-collaboration
Meeting
IoT
IoT
Intelligent EdgeFabric
DeveloperTools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Updated at: Apr 02, 2022 GMT+08:00

Enabling or Disabling FileStream

Scenarios

FileStream of SQL Server stores unstructured data, such as documents and images, in file systems, effectively improving the database performance.

Constraints

  • Enabling or disabling FileStream for a DB instance will reboot the DB instance. A DB instance reboot takes about 3 to 5 minutes. Services are unavailable when a DB instance is rebooting.
  • This feature is supported only for single instances and 2017 Enterprise Edition cluster instances.
  • FileStream cannot be disabled for a DB instance when databases of the DB instance have been created with this feature enabled. If you need to disable this feature, delete the databases first.
  • Databases of a DB instance with FileStream enabled cannot be created using v3 APIs. For details about how to create a database using APIs, see Creating a Database.
  • After you enable FileStream, the DB instance type cannot be changed from single to primary/standby.
  • The backups generated after you enable FileStream can only be restored to an existing instance (not the original one) or a new instance, and the instance must be a single instance or 2017 Enterprise Edition cluster instance.
    • If you want to restore to an existing DB instance (not the original one), ensure that FileStream has been enabled for this DB instance.
    • If you want to restore to a new DB instance, FileStream will be automatically enabled for the new DB instance.

Enabling FileStream

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Database > Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance. In the DB Information area on the Basic Information page, click in the FileStream field.
  5. In the displayed dialog box, click Yes.

    Enabling FileStream will reboot your DB instance, and services will be unavailable during the reboot. Exercise caution when performing this operation.

    Figure 1 Enabling FileStream

Disabling FileStream

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Database > Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance. In the DB Information area on the Basic Information page, click in the FileStream field.
  5. In the displayed dialog box, click Yes to disable FileStream.

    Disabling FileStream will cause your DB instance to reboot, and services will be unavailable during the reboot. Exercise caution when performing this operation.

    Figure 2 Disabling FileStream

Parameters

filestream access level

Default value: 0

Function: Use this parameter to change the FileStream access level for your RDS for SQL Server DB instance.

Value range:

  • 0: disables this function.
  • 1: enables this function for Transact-SQL access.
  • 2: enables this function for all streaming access.

    To change the parameter value, see Modifying Parameters.

Impact:

  • If FileStream is enabled, set this parameter to 1 or 2.
  • If FileStream is disabled, you can set this parameter only to 0.

Did you find this page helpful?

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel