1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. SqlserverConfigBackupStrategy
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloud.SqlserverConfigBackupStrategy

Explore with Pulumi AI

tencentcloud logo
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

    Provides a resource to create a sqlserver config_backup_strategy

    Example Usage

    Daily backup

    import * as pulumi from "@pulumi/pulumi";
    import * as tencentcloud from "@pulumi/tencentcloud";
    
    const zones = tencentcloud.getAvailabilityZonesByProduct({
        product: "sqlserver",
    });
    const vpc = new tencentcloud.Vpc("vpc", {cidrBlock: "10.0.0.0/16"});
    const subnet = new tencentcloud.Subnet("subnet", {
        availabilityZone: zones.then(zones => zones.zones?.[4]?.name),
        vpcId: vpc.vpcId,
        cidrBlock: "10.0.0.0/16",
        isMulticast: false,
    });
    const securityGroup = new tencentcloud.SecurityGroup("securityGroup", {description: "desc."});
    const exampleSqlserverBasicInstance = new tencentcloud.SqlserverBasicInstance("exampleSqlserverBasicInstance", {
        availabilityZone: zones.then(zones => zones.zones?.[4]?.name),
        chargeType: "POSTPAID_BY_HOUR",
        vpcId: vpc.vpcId,
        subnetId: subnet.subnetId,
        projectId: 0,
        memory: 4,
        storage: 100,
        cpu: 2,
        machineType: "CLOUD_PREMIUM",
        maintenanceWeekSets: [
            1,
            2,
            3,
        ],
        maintenanceStartTime: "09:00",
        maintenanceTimeSpan: 3,
        securityGroups: [securityGroup.securityGroupId],
        tags: {
            test: "test",
        },
    });
    const exampleSqlserverConfigBackupStrategy = new tencentcloud.SqlserverConfigBackupStrategy("exampleSqlserverConfigBackupStrategy", {
        instanceId: exampleSqlserverBasicInstance.sqlserverBasicInstanceId,
        backupType: "daily",
        backupTime: 0,
        backupDay: 1,
        backupModel: "master_no_pkg",
        backupCycles: [1],
        backupSaveDays: 7,
        regularBackupEnable: "disable",
        regularBackupSaveDays: 90,
        regularBackupStrategy: "months",
        regularBackupCounts: 1,
    });
    
    import pulumi
    import pulumi_tencentcloud as tencentcloud
    
    zones = tencentcloud.get_availability_zones_by_product(product="sqlserver")
    vpc = tencentcloud.Vpc("vpc", cidr_block="10.0.0.0/16")
    subnet = tencentcloud.Subnet("subnet",
        availability_zone=zones.zones[4].name,
        vpc_id=vpc.vpc_id,
        cidr_block="10.0.0.0/16",
        is_multicast=False)
    security_group = tencentcloud.SecurityGroup("securityGroup", description="desc.")
    example_sqlserver_basic_instance = tencentcloud.SqlserverBasicInstance("exampleSqlserverBasicInstance",
        availability_zone=zones.zones[4].name,
        charge_type="POSTPAID_BY_HOUR",
        vpc_id=vpc.vpc_id,
        subnet_id=subnet.subnet_id,
        project_id=0,
        memory=4,
        storage=100,
        cpu=2,
        machine_type="CLOUD_PREMIUM",
        maintenance_week_sets=[
            1,
            2,
            3,
        ],
        maintenance_start_time="09:00",
        maintenance_time_span=3,
        security_groups=[security_group.security_group_id],
        tags={
            "test": "test",
        })
    example_sqlserver_config_backup_strategy = tencentcloud.SqlserverConfigBackupStrategy("exampleSqlserverConfigBackupStrategy",
        instance_id=example_sqlserver_basic_instance.sqlserver_basic_instance_id,
        backup_type="daily",
        backup_time=0,
        backup_day=1,
        backup_model="master_no_pkg",
        backup_cycles=[1],
        backup_save_days=7,
        regular_backup_enable="disable",
        regular_backup_save_days=90,
        regular_backup_strategy="months",
        regular_backup_counts=1)
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		zones, err := tencentcloud.GetAvailabilityZonesByProduct(ctx, &tencentcloud.GetAvailabilityZonesByProductArgs{
    			Product: "sqlserver",
    		}, nil)
    		if err != nil {
    			return err
    		}
    		vpc, err := tencentcloud.NewVpc(ctx, "vpc", &tencentcloud.VpcArgs{
    			CidrBlock: pulumi.String("10.0.0.0/16"),
    		})
    		if err != nil {
    			return err
    		}
    		subnet, err := tencentcloud.NewSubnet(ctx, "subnet", &tencentcloud.SubnetArgs{
    			AvailabilityZone: pulumi.String(zones.Zones[4].Name),
    			VpcId:            vpc.VpcId,
    			CidrBlock:        pulumi.String("10.0.0.0/16"),
    			IsMulticast:      pulumi.Bool(false),
    		})
    		if err != nil {
    			return err
    		}
    		securityGroup, err := tencentcloud.NewSecurityGroup(ctx, "securityGroup", &tencentcloud.SecurityGroupArgs{
    			Description: pulumi.String("desc."),
    		})
    		if err != nil {
    			return err
    		}
    		exampleSqlserverBasicInstance, err := tencentcloud.NewSqlserverBasicInstance(ctx, "exampleSqlserverBasicInstance", &tencentcloud.SqlserverBasicInstanceArgs{
    			AvailabilityZone: pulumi.String(zones.Zones[4].Name),
    			ChargeType:       pulumi.String("POSTPAID_BY_HOUR"),
    			VpcId:            vpc.VpcId,
    			SubnetId:         subnet.SubnetId,
    			ProjectId:        pulumi.Float64(0),
    			Memory:           pulumi.Float64(4),
    			Storage:          pulumi.Float64(100),
    			Cpu:              pulumi.Float64(2),
    			MachineType:      pulumi.String("CLOUD_PREMIUM"),
    			MaintenanceWeekSets: pulumi.Float64Array{
    				pulumi.Float64(1),
    				pulumi.Float64(2),
    				pulumi.Float64(3),
    			},
    			MaintenanceStartTime: pulumi.String("09:00"),
    			MaintenanceTimeSpan:  pulumi.Float64(3),
    			SecurityGroups: pulumi.StringArray{
    				securityGroup.SecurityGroupId,
    			},
    			Tags: pulumi.StringMap{
    				"test": pulumi.String("test"),
    			},
    		})
    		if err != nil {
    			return err
    		}
    		_, err = tencentcloud.NewSqlserverConfigBackupStrategy(ctx, "exampleSqlserverConfigBackupStrategy", &tencentcloud.SqlserverConfigBackupStrategyArgs{
    			InstanceId:  exampleSqlserverBasicInstance.SqlserverBasicInstanceId,
    			BackupType:  pulumi.String("daily"),
    			BackupTime:  pulumi.Float64(0),
    			BackupDay:   pulumi.Float64(1),
    			BackupModel: pulumi.String("master_no_pkg"),
    			BackupCycles: pulumi.Float64Array{
    				pulumi.Float64(1),
    			},
    			BackupSaveDays:        pulumi.Float64(7),
    			RegularBackupEnable:   pulumi.String("disable"),
    			RegularBackupSaveDays: pulumi.Float64(90),
    			RegularBackupStrategy: pulumi.String("months"),
    			RegularBackupCounts:   pulumi.Float64(1),
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Tencentcloud = Pulumi.Tencentcloud;
    
    return await Deployment.RunAsync(() => 
    {
        var zones = Tencentcloud.GetAvailabilityZonesByProduct.Invoke(new()
        {
            Product = "sqlserver",
        });
    
        var vpc = new Tencentcloud.Vpc("vpc", new()
        {
            CidrBlock = "10.0.0.0/16",
        });
    
        var subnet = new Tencentcloud.Subnet("subnet", new()
        {
            AvailabilityZone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
            VpcId = vpc.VpcId,
            CidrBlock = "10.0.0.0/16",
            IsMulticast = false,
        });
    
        var securityGroup = new Tencentcloud.SecurityGroup("securityGroup", new()
        {
            Description = "desc.",
        });
    
        var exampleSqlserverBasicInstance = new Tencentcloud.SqlserverBasicInstance("exampleSqlserverBasicInstance", new()
        {
            AvailabilityZone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
            ChargeType = "POSTPAID_BY_HOUR",
            VpcId = vpc.VpcId,
            SubnetId = subnet.SubnetId,
            ProjectId = 0,
            Memory = 4,
            Storage = 100,
            Cpu = 2,
            MachineType = "CLOUD_PREMIUM",
            MaintenanceWeekSets = new[]
            {
                1,
                2,
                3,
            },
            MaintenanceStartTime = "09:00",
            MaintenanceTimeSpan = 3,
            SecurityGroups = new[]
            {
                securityGroup.SecurityGroupId,
            },
            Tags = 
            {
                { "test", "test" },
            },
        });
    
        var exampleSqlserverConfigBackupStrategy = new Tencentcloud.SqlserverConfigBackupStrategy("exampleSqlserverConfigBackupStrategy", new()
        {
            InstanceId = exampleSqlserverBasicInstance.SqlserverBasicInstanceId,
            BackupType = "daily",
            BackupTime = 0,
            BackupDay = 1,
            BackupModel = "master_no_pkg",
            BackupCycles = new[]
            {
                1,
            },
            BackupSaveDays = 7,
            RegularBackupEnable = "disable",
            RegularBackupSaveDays = 90,
            RegularBackupStrategy = "months",
            RegularBackupCounts = 1,
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.tencentcloud.TencentcloudFunctions;
    import com.pulumi.tencentcloud.inputs.GetAvailabilityZonesByProductArgs;
    import com.pulumi.tencentcloud.Vpc;
    import com.pulumi.tencentcloud.VpcArgs;
    import com.pulumi.tencentcloud.Subnet;
    import com.pulumi.tencentcloud.SubnetArgs;
    import com.pulumi.tencentcloud.SecurityGroup;
    import com.pulumi.tencentcloud.SecurityGroupArgs;
    import com.pulumi.tencentcloud.SqlserverBasicInstance;
    import com.pulumi.tencentcloud.SqlserverBasicInstanceArgs;
    import com.pulumi.tencentcloud.SqlserverConfigBackupStrategy;
    import com.pulumi.tencentcloud.SqlserverConfigBackupStrategyArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            final var zones = TencentcloudFunctions.getAvailabilityZonesByProduct(GetAvailabilityZonesByProductArgs.builder()
                .product("sqlserver")
                .build());
    
            var vpc = new Vpc("vpc", VpcArgs.builder()
                .cidrBlock("10.0.0.0/16")
                .build());
    
            var subnet = new Subnet("subnet", SubnetArgs.builder()
                .availabilityZone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[4].name()))
                .vpcId(vpc.vpcId())
                .cidrBlock("10.0.0.0/16")
                .isMulticast(false)
                .build());
    
            var securityGroup = new SecurityGroup("securityGroup", SecurityGroupArgs.builder()
                .description("desc.")
                .build());
    
            var exampleSqlserverBasicInstance = new SqlserverBasicInstance("exampleSqlserverBasicInstance", SqlserverBasicInstanceArgs.builder()
                .availabilityZone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[4].name()))
                .chargeType("POSTPAID_BY_HOUR")
                .vpcId(vpc.vpcId())
                .subnetId(subnet.subnetId())
                .projectId(0)
                .memory(4)
                .storage(100)
                .cpu(2)
                .machineType("CLOUD_PREMIUM")
                .maintenanceWeekSets(            
                    1,
                    2,
                    3)
                .maintenanceStartTime("09:00")
                .maintenanceTimeSpan(3)
                .securityGroups(securityGroup.securityGroupId())
                .tags(Map.of("test", "test"))
                .build());
    
            var exampleSqlserverConfigBackupStrategy = new SqlserverConfigBackupStrategy("exampleSqlserverConfigBackupStrategy", SqlserverConfigBackupStrategyArgs.builder()
                .instanceId(exampleSqlserverBasicInstance.sqlserverBasicInstanceId())
                .backupType("daily")
                .backupTime(0)
                .backupDay(1)
                .backupModel("master_no_pkg")
                .backupCycles(1)
                .backupSaveDays(7)
                .regularBackupEnable("disable")
                .regularBackupSaveDays(90)
                .regularBackupStrategy("months")
                .regularBackupCounts(1)
                .build());
    
        }
    }
    
    resources:
      vpc:
        type: tencentcloud:Vpc
        properties:
          cidrBlock: 10.0.0.0/16
      subnet:
        type: tencentcloud:Subnet
        properties:
          availabilityZone: ${zones.zones[4].name}
          vpcId: ${vpc.vpcId}
          cidrBlock: 10.0.0.0/16
          isMulticast: false
      securityGroup:
        type: tencentcloud:SecurityGroup
        properties:
          description: desc.
      exampleSqlserverBasicInstance:
        type: tencentcloud:SqlserverBasicInstance
        properties:
          availabilityZone: ${zones.zones[4].name}
          chargeType: POSTPAID_BY_HOUR
          vpcId: ${vpc.vpcId}
          subnetId: ${subnet.subnetId}
          projectId: 0
          memory: 4
          storage: 100
          cpu: 2
          machineType: CLOUD_PREMIUM
          maintenanceWeekSets:
            - 1
            - 2
            - 3
          maintenanceStartTime: 09:00
          maintenanceTimeSpan: 3
          securityGroups:
            - ${securityGroup.securityGroupId}
          tags:
            test: test
      exampleSqlserverConfigBackupStrategy:
        type: tencentcloud:SqlserverConfigBackupStrategy
        properties:
          instanceId: ${exampleSqlserverBasicInstance.sqlserverBasicInstanceId}
          backupType: daily
          backupTime: 0
          backupDay: 1
          backupModel: master_no_pkg
          backupCycles:
            - 1
          backupSaveDays: 7
          regularBackupEnable: disable
          regularBackupSaveDays: 90
          regularBackupStrategy: months
          regularBackupCounts: 1
    variables:
      zones:
        fn::invoke:
          function: tencentcloud:getAvailabilityZonesByProduct
          arguments:
            product: sqlserver
    

    Weekly backup

    import * as pulumi from "@pulumi/pulumi";
    import * as tencentcloud from "@pulumi/tencentcloud";
    
    const example = new tencentcloud.SqlserverConfigBackupStrategy("example", {
        instanceId: tencentcloud_sqlserver_basic_instance.example.id,
        backupType: "weekly",
        backupTime: 0,
        backupModel: "master_no_pkg",
        backupCycles: [
            1,
            3,
            5,
        ],
        backupSaveDays: 7,
        regularBackupEnable: "disable",
        regularBackupSaveDays: 90,
        regularBackupStrategy: "months",
        regularBackupCounts: 1,
    });
    
    import pulumi
    import pulumi_tencentcloud as tencentcloud
    
    example = tencentcloud.SqlserverConfigBackupStrategy("example",
        instance_id=tencentcloud_sqlserver_basic_instance["example"]["id"],
        backup_type="weekly",
        backup_time=0,
        backup_model="master_no_pkg",
        backup_cycles=[
            1,
            3,
            5,
        ],
        backup_save_days=7,
        regular_backup_enable="disable",
        regular_backup_save_days=90,
        regular_backup_strategy="months",
        regular_backup_counts=1)
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := tencentcloud.NewSqlserverConfigBackupStrategy(ctx, "example", &tencentcloud.SqlserverConfigBackupStrategyArgs{
    			InstanceId:  pulumi.Any(tencentcloud_sqlserver_basic_instance.Example.Id),
    			BackupType:  pulumi.String("weekly"),
    			BackupTime:  pulumi.Float64(0),
    			BackupModel: pulumi.String("master_no_pkg"),
    			BackupCycles: pulumi.Float64Array{
    				pulumi.Float64(1),
    				pulumi.Float64(3),
    				pulumi.Float64(5),
    			},
    			BackupSaveDays:        pulumi.Float64(7),
    			RegularBackupEnable:   pulumi.String("disable"),
    			RegularBackupSaveDays: pulumi.Float64(90),
    			RegularBackupStrategy: pulumi.String("months"),
    			RegularBackupCounts:   pulumi.Float64(1),
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Tencentcloud = Pulumi.Tencentcloud;
    
    return await Deployment.RunAsync(() => 
    {
        var example = new Tencentcloud.SqlserverConfigBackupStrategy("example", new()
        {
            InstanceId = tencentcloud_sqlserver_basic_instance.Example.Id,
            BackupType = "weekly",
            BackupTime = 0,
            BackupModel = "master_no_pkg",
            BackupCycles = new[]
            {
                1,
                3,
                5,
            },
            BackupSaveDays = 7,
            RegularBackupEnable = "disable",
            RegularBackupSaveDays = 90,
            RegularBackupStrategy = "months",
            RegularBackupCounts = 1,
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.tencentcloud.SqlserverConfigBackupStrategy;
    import com.pulumi.tencentcloud.SqlserverConfigBackupStrategyArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var example = new SqlserverConfigBackupStrategy("example", SqlserverConfigBackupStrategyArgs.builder()
                .instanceId(tencentcloud_sqlserver_basic_instance.example().id())
                .backupType("weekly")
                .backupTime(0)
                .backupModel("master_no_pkg")
                .backupCycles(            
                    1,
                    3,
                    5)
                .backupSaveDays(7)
                .regularBackupEnable("disable")
                .regularBackupSaveDays(90)
                .regularBackupStrategy("months")
                .regularBackupCounts(1)
                .build());
    
        }
    }
    
    resources:
      example:
        type: tencentcloud:SqlserverConfigBackupStrategy
        properties:
          instanceId: ${tencentcloud_sqlserver_basic_instance.example.id}
          backupType: weekly
          backupTime: 0
          backupModel: master_no_pkg
          backupCycles:
            - 1
            - 3
            - 5
          backupSaveDays: 7
          regularBackupEnable: disable
          regularBackupSaveDays: 90
          regularBackupStrategy: months
          regularBackupCounts: 1
    

    Regular backup

    import * as pulumi from "@pulumi/pulumi";
    import * as tencentcloud from "@pulumi/tencentcloud";
    
    const example = new tencentcloud.SqlserverConfigBackupStrategy("example", {
        instanceId: tencentcloud_sqlserver_basic_instance.example.id,
        backupTime: 0,
        backupModel: "master_no_pkg",
        backupCycles: [
            1,
            3,
        ],
        backupSaveDays: 7,
        regularBackupEnable: "enable",
        regularBackupSaveDays: 120,
        regularBackupStrategy: "months",
        regularBackupCounts: 1,
        regularBackupStartTime: "%s",
    });
    
    import pulumi
    import pulumi_tencentcloud as tencentcloud
    
    example = tencentcloud.SqlserverConfigBackupStrategy("example",
        instance_id=tencentcloud_sqlserver_basic_instance["example"]["id"],
        backup_time=0,
        backup_model="master_no_pkg",
        backup_cycles=[
            1,
            3,
        ],
        backup_save_days=7,
        regular_backup_enable="enable",
        regular_backup_save_days=120,
        regular_backup_strategy="months",
        regular_backup_counts=1,
        regular_backup_start_time="%s")
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := tencentcloud.NewSqlserverConfigBackupStrategy(ctx, "example", &tencentcloud.SqlserverConfigBackupStrategyArgs{
    			InstanceId:  pulumi.Any(tencentcloud_sqlserver_basic_instance.Example.Id),
    			BackupTime:  pulumi.Float64(0),
    			BackupModel: pulumi.String("master_no_pkg"),
    			BackupCycles: pulumi.Float64Array{
    				pulumi.Float64(1),
    				pulumi.Float64(3),
    			},
    			BackupSaveDays:         pulumi.Float64(7),
    			RegularBackupEnable:    pulumi.String("enable"),
    			RegularBackupSaveDays:  pulumi.Float64(120),
    			RegularBackupStrategy:  pulumi.String("months"),
    			RegularBackupCounts:    pulumi.Float64(1),
    			RegularBackupStartTime: pulumi.String("%s"),
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Tencentcloud = Pulumi.Tencentcloud;
    
    return await Deployment.RunAsync(() => 
    {
        var example = new Tencentcloud.SqlserverConfigBackupStrategy("example", new()
        {
            InstanceId = tencentcloud_sqlserver_basic_instance.Example.Id,
            BackupTime = 0,
            BackupModel = "master_no_pkg",
            BackupCycles = new[]
            {
                1,
                3,
            },
            BackupSaveDays = 7,
            RegularBackupEnable = "enable",
            RegularBackupSaveDays = 120,
            RegularBackupStrategy = "months",
            RegularBackupCounts = 1,
            RegularBackupStartTime = "%s",
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.tencentcloud.SqlserverConfigBackupStrategy;
    import com.pulumi.tencentcloud.SqlserverConfigBackupStrategyArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var example = new SqlserverConfigBackupStrategy("example", SqlserverConfigBackupStrategyArgs.builder()
                .instanceId(tencentcloud_sqlserver_basic_instance.example().id())
                .backupTime(0)
                .backupModel("master_no_pkg")
                .backupCycles(            
                    1,
                    3)
                .backupSaveDays(7)
                .regularBackupEnable("enable")
                .regularBackupSaveDays(120)
                .regularBackupStrategy("months")
                .regularBackupCounts(1)
                .regularBackupStartTime("%s")
                .build());
    
        }
    }
    
    resources:
      example:
        type: tencentcloud:SqlserverConfigBackupStrategy
        properties:
          instanceId: ${tencentcloud_sqlserver_basic_instance.example.id}
          backupTime: 0
          backupModel: master_no_pkg
          backupCycles:
            - 1
            - 3
          backupSaveDays: 7
          regularBackupEnable: enable
          regularBackupSaveDays: 120
          regularBackupStrategy: months
          regularBackupCounts: 1
          regularBackupStartTime: '%s'
    

    Create SqlserverConfigBackupStrategy Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new SqlserverConfigBackupStrategy(name: string, args: SqlserverConfigBackupStrategyArgs, opts?: CustomResourceOptions);
    @overload
    def SqlserverConfigBackupStrategy(resource_name: str,
                                      args: SqlserverConfigBackupStrategyArgs,
                                      opts: Optional[ResourceOptions] = None)
    
    @overload
    def SqlserverConfigBackupStrategy(resource_name: str,
                                      opts: Optional[ResourceOptions] = None,
                                      instance_id: Optional[str] = None,
                                      backup_save_days: Optional[float] = None,
                                      backup_model: Optional[str] = None,
                                      backup_cycles: Optional[Sequence[float]] = None,
                                      backup_time: Optional[float] = None,
                                      backup_type: Optional[str] = None,
                                      backup_day: Optional[float] = None,
                                      regular_backup_counts: Optional[float] = None,
                                      regular_backup_enable: Optional[str] = None,
                                      regular_backup_save_days: Optional[float] = None,
                                      regular_backup_start_time: Optional[str] = None,
                                      regular_backup_strategy: Optional[str] = None,
                                      sqlserver_config_backup_strategy_id: Optional[str] = None)
    func NewSqlserverConfigBackupStrategy(ctx *Context, name string, args SqlserverConfigBackupStrategyArgs, opts ...ResourceOption) (*SqlserverConfigBackupStrategy, error)
    public SqlserverConfigBackupStrategy(string name, SqlserverConfigBackupStrategyArgs args, CustomResourceOptions? opts = null)
    public SqlserverConfigBackupStrategy(String name, SqlserverConfigBackupStrategyArgs args)
    public SqlserverConfigBackupStrategy(String name, SqlserverConfigBackupStrategyArgs args, CustomResourceOptions options)
    
    type: tencentcloud:SqlserverConfigBackupStrategy
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    

    Parameters

    name string
    The unique name of the resource.
    args SqlserverConfigBackupStrategyArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args SqlserverConfigBackupStrategyArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args SqlserverConfigBackupStrategyArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SqlserverConfigBackupStrategyArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SqlserverConfigBackupStrategyArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    SqlserverConfigBackupStrategy Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The SqlserverConfigBackupStrategy resource accepts the following input properties:

    InstanceId string
    Instance ID.
    BackupCycles List<double>
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    BackupDay double
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    BackupModel string
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    BackupSaveDays double
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    BackupTime double
    Backup time. Value range: an integer from 0 to 23.
    BackupType string
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    RegularBackupCounts double
    The number of retained archive backups. Default value: 1.
    RegularBackupEnable string
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    RegularBackupSaveDays double
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    RegularBackupStartTime string
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    RegularBackupStrategy string
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    SqlserverConfigBackupStrategyId string
    ID of the resource.
    InstanceId string
    Instance ID.
    BackupCycles []float64
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    BackupDay float64
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    BackupModel string
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    BackupSaveDays float64
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    BackupTime float64
    Backup time. Value range: an integer from 0 to 23.
    BackupType string
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    RegularBackupCounts float64
    The number of retained archive backups. Default value: 1.
    RegularBackupEnable string
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    RegularBackupSaveDays float64
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    RegularBackupStartTime string
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    RegularBackupStrategy string
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    SqlserverConfigBackupStrategyId string
    ID of the resource.
    instanceId String
    Instance ID.
    backupCycles List<Double>
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    backupDay Double
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    backupModel String
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    backupSaveDays Double
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    backupTime Double
    Backup time. Value range: an integer from 0 to 23.
    backupType String
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    regularBackupCounts Double
    The number of retained archive backups. Default value: 1.
    regularBackupEnable String
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    regularBackupSaveDays Double
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    regularBackupStartTime String
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    regularBackupStrategy String
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    sqlserverConfigBackupStrategyId String
    ID of the resource.
    instanceId string
    Instance ID.
    backupCycles number[]
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    backupDay number
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    backupModel string
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    backupSaveDays number
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    backupTime number
    Backup time. Value range: an integer from 0 to 23.
    backupType string
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    regularBackupCounts number
    The number of retained archive backups. Default value: 1.
    regularBackupEnable string
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    regularBackupSaveDays number
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    regularBackupStartTime string
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    regularBackupStrategy string
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    sqlserverConfigBackupStrategyId string
    ID of the resource.
    instance_id str
    Instance ID.
    backup_cycles Sequence[float]
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    backup_day float
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    backup_model str
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    backup_save_days float
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    backup_time float
    Backup time. Value range: an integer from 0 to 23.
    backup_type str
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    regular_backup_counts float
    The number of retained archive backups. Default value: 1.
    regular_backup_enable str
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    regular_backup_save_days float
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    regular_backup_start_time str
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    regular_backup_strategy str
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    sqlserver_config_backup_strategy_id str
    ID of the resource.
    instanceId String
    Instance ID.
    backupCycles List<Number>
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    backupDay Number
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    backupModel String
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    backupSaveDays Number
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    backupTime Number
    Backup time. Value range: an integer from 0 to 23.
    backupType String
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    regularBackupCounts Number
    The number of retained archive backups. Default value: 1.
    regularBackupEnable String
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    regularBackupSaveDays Number
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    regularBackupStartTime String
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    regularBackupStrategy String
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    sqlserverConfigBackupStrategyId String
    ID of the resource.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the SqlserverConfigBackupStrategy resource produces the following output properties:

    Id string
    The provider-assigned unique ID for this managed resource.
    Id string
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.
    id string
    The provider-assigned unique ID for this managed resource.
    id str
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing SqlserverConfigBackupStrategy Resource

    Get an existing SqlserverConfigBackupStrategy resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: SqlserverConfigBackupStrategyState, opts?: CustomResourceOptions): SqlserverConfigBackupStrategy
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            backup_cycles: Optional[Sequence[float]] = None,
            backup_day: Optional[float] = None,
            backup_model: Optional[str] = None,
            backup_save_days: Optional[float] = None,
            backup_time: Optional[float] = None,
            backup_type: Optional[str] = None,
            instance_id: Optional[str] = None,
            regular_backup_counts: Optional[float] = None,
            regular_backup_enable: Optional[str] = None,
            regular_backup_save_days: Optional[float] = None,
            regular_backup_start_time: Optional[str] = None,
            regular_backup_strategy: Optional[str] = None,
            sqlserver_config_backup_strategy_id: Optional[str] = None) -> SqlserverConfigBackupStrategy
    func GetSqlserverConfigBackupStrategy(ctx *Context, name string, id IDInput, state *SqlserverConfigBackupStrategyState, opts ...ResourceOption) (*SqlserverConfigBackupStrategy, error)
    public static SqlserverConfigBackupStrategy Get(string name, Input<string> id, SqlserverConfigBackupStrategyState? state, CustomResourceOptions? opts = null)
    public static SqlserverConfigBackupStrategy get(String name, Output<String> id, SqlserverConfigBackupStrategyState state, CustomResourceOptions options)
    resources:  _:    type: tencentcloud:SqlserverConfigBackupStrategy    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    BackupCycles List<double>
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    BackupDay double
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    BackupModel string
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    BackupSaveDays double
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    BackupTime double
    Backup time. Value range: an integer from 0 to 23.
    BackupType string
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    InstanceId string
    Instance ID.
    RegularBackupCounts double
    The number of retained archive backups. Default value: 1.
    RegularBackupEnable string
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    RegularBackupSaveDays double
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    RegularBackupStartTime string
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    RegularBackupStrategy string
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    SqlserverConfigBackupStrategyId string
    ID of the resource.
    BackupCycles []float64
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    BackupDay float64
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    BackupModel string
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    BackupSaveDays float64
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    BackupTime float64
    Backup time. Value range: an integer from 0 to 23.
    BackupType string
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    InstanceId string
    Instance ID.
    RegularBackupCounts float64
    The number of retained archive backups. Default value: 1.
    RegularBackupEnable string
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    RegularBackupSaveDays float64
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    RegularBackupStartTime string
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    RegularBackupStrategy string
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    SqlserverConfigBackupStrategyId string
    ID of the resource.
    backupCycles List<Double>
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    backupDay Double
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    backupModel String
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    backupSaveDays Double
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    backupTime Double
    Backup time. Value range: an integer from 0 to 23.
    backupType String
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    instanceId String
    Instance ID.
    regularBackupCounts Double
    The number of retained archive backups. Default value: 1.
    regularBackupEnable String
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    regularBackupSaveDays Double
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    regularBackupStartTime String
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    regularBackupStrategy String
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    sqlserverConfigBackupStrategyId String
    ID of the resource.
    backupCycles number[]
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    backupDay number
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    backupModel string
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    backupSaveDays number
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    backupTime number
    Backup time. Value range: an integer from 0 to 23.
    backupType string
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    instanceId string
    Instance ID.
    regularBackupCounts number
    The number of retained archive backups. Default value: 1.
    regularBackupEnable string
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    regularBackupSaveDays number
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    regularBackupStartTime string
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    regularBackupStrategy string
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    sqlserverConfigBackupStrategyId string
    ID of the resource.
    backup_cycles Sequence[float]
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    backup_day float
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    backup_model str
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    backup_save_days float
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    backup_time float
    Backup time. Value range: an integer from 0 to 23.
    backup_type str
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    instance_id str
    Instance ID.
    regular_backup_counts float
    The number of retained archive backups. Default value: 1.
    regular_backup_enable str
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    regular_backup_save_days float
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    regular_backup_start_time str
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    regular_backup_strategy str
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    sqlserver_config_backup_strategy_id str
    ID of the resource.
    backupCycles List<Number>
    The days of the week on which backup will be performed when BackupType is weekly. If data backup retention period is less than 7 days, the values will be 1-7, indicating that backup will be performed everyday by default; if data backup retention period is greater than or equal to 7 days, the values will be at least any two days, indicating that backup will be performed at least twice in a week by default.
    backupDay Number
    Backup interval in days when the BackupType is daily. The current value can only be 1.
    backupModel String
    Backup mode. Valid values: master_pkg (archive the backup files of the primary node), master_no_pkg (do not archive the backup files of the primary node), slave_pkg (archive the backup files of the replica node), slave_no_pkg (do not archive the backup files of the replica node). Backup files of the replica node are supported only when Always On disaster recovery is enabled.
    backupSaveDays Number
    Data (log) backup retention period. Value range: 3-1830 days, default value: 7 days.
    backupTime Number
    Backup time. Value range: an integer from 0 to 23.
    backupType String
    Backup type. Valid values: weekly (when length(BackupDay) <=7 && length(BackupDay) >=2), daily (when length(BackupDay)=1). Default value: daily.
    instanceId String
    Instance ID.
    regularBackupCounts Number
    The number of retained archive backups. Default value: 1.
    regularBackupEnable String
    Archive backup status. Valid values: enable (enabled); disable (disabled). Default value: disable.
    regularBackupSaveDays Number
    Archive backup retention days. Value range: 90-3650 days. Default value: 365 days.
    regularBackupStartTime String
    Archive backup start date in YYYY-MM-DD format, which is the current time by default.
    regularBackupStrategy String
    Archive backup policy. Valid values: years (yearly); quarters (quarterly); months(monthly); Default value: months.
    sqlserverConfigBackupStrategyId String
    ID of the resource.

    Import

    sqlserver config_backup_strategy can be imported using the id, e.g.

    $ pulumi import tencentcloud:index/sqlserverConfigBackupStrategy:SqlserverConfigBackupStrategy example mssql-si2823jyl
    

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    tencentcloud tencentcloudstack/terraform-provider-tencentcloud
    License
    Notes
    This Pulumi package is based on the tencentcloud Terraform Provider.
    tencentcloud logo
    tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack