New-AzSqlVM
Crea o actualiza una máquina virtual SQL.
Syntax
New-AzSqlVM
-Name <String>
-ResourceGroupName <String>
[-SubscriptionId <String>]
-Location <String>
[-AdditionalFeatureServerConfigurationIsRServicesEnabled]
[-AssessmentSettingEnable]
[-AssessmentSettingRunImmediately]
[-AutoBackupSettingBackupScheduleType <BackupScheduleType>]
[-AutoBackupSettingBackupSystemDb]
[-AutoBackupSettingDaysOfWeek <AutoBackupDaysOfWeek[]>]
[-AutoBackupSettingEnable]
[-AutoBackupSettingEnableEncryption]
[-AutoBackupSettingFullBackupFrequency <FullBackupFrequencyType>]
[-AutoBackupSettingFullBackupStartTime <Int32>]
[-AutoBackupSettingFullBackupWindowHour <Int32>]
[-AutoBackupSettingLogBackupFrequency <Int32>]
[-AutoBackupSettingPassword <SecureString>]
[-AutoBackupSettingRetentionPeriod <Int32>]
[-AutoBackupSettingStorageAccessKey <String>]
[-AutoBackupSettingStorageAccountUrl <String>]
[-AutoBackupSettingStorageContainerName <String>]
[-AutoPatchingSettingDayOfWeek <DayOfWeek>]
[-AutoPatchingSettingEnable]
[-AutoPatchingSettingMaintenanceWindowDuration <Int32>]
[-AutoPatchingSettingMaintenanceWindowStartingHour <Int32>]
[-AzureAdAuthenticationSettingClientId <String>]
[-EnableAutomaticUpgrade]
[-IdentityType <IdentityType>]
[-KeyVaultCredentialSettingAzureKeyVaultUrl <String>]
[-KeyVaultCredentialSettingCredentialName <String>]
[-KeyVaultCredentialSettingEnable]
[-KeyVaultCredentialSettingServicePrincipalName <String>]
[-KeyVaultCredentialSettingServicePrincipalSecret <String>]
[-LeastPrivilegeMode <LeastPrivilegeMode>]
[-LicenseType <SqlServerLicenseType>]
[-Offer <String>]
[-ScheduleDayOfWeek <AssessmentDayOfWeek>]
[-ScheduleEnable]
[-ScheduleMonthlyOccurrence <Int32>]
[-ScheduleStartTime <String>]
[-ScheduleWeeklyInterval <Int32>]
[-Sku <SqlImageSku>]
[-SqlConnectivityUpdateSettingConnectivityType <ConnectivityType>]
[-SqlConnectivityUpdateSettingPort <Int32>]
[-SqlConnectivityUpdateSettingSqlAuthUpdatePassword <SecureString>]
[-SqlConnectivityUpdateSettingSqlAuthUpdateUserName <String>]
[-SqlDataSettingDefaultFilePath <String>]
[-SqlDataSettingLun <Int32[]>]
[-SqlInstanceSettingCollation <String>]
[-SqlInstanceSettingIsIfiEnabled]
[-SqlInstanceSettingIsLpimEnabled]
[-SqlInstanceSettingIsOptimizeForAdHocWorkloadsEnabled]
[-SqlInstanceSettingMaxDop <Int32>]
[-SqlInstanceSettingMaxServerMemoryMb <Int32>]
[-SqlInstanceSettingMinServerMemoryMb <Int32>]
[-SqlLogSettingDefaultFilePath <String>]
[-SqlLogSettingLun <Int32[]>]
[-SqlManagementType <SqlManagementMode>]
[-SqlStorageUpdateSettingDiskConfigurationType <DiskConfigurationType>]
[-SqlStorageUpdateSettingDiskCount <Int32>]
[-SqlStorageUpdateSettingStartingDeviceId <Int32>]
[-SqlTempDbSettingDataFileCount <Int32>]
[-SqlTempDbSettingDataFileSize <Int32>]
[-SqlTempDbSettingDataGrowth <Int32>]
[-SqlTempDbSettingDefaultFilePath <String>]
[-SqlTempDbSettingLogFileSize <Int32>]
[-SqlTempDbSettingLogGrowth <Int32>]
[-SqlTempDbSettingLun <Int32[]>]
[-SqlTempDbSettingPersistFolder]
[-SqlTempDbSettingPersistFolderPath <String>]
[-SqlVirtualMachineGroupResourceId <String>]
[-SqlWorkloadTypeUpdateSettingSqlWorkloadType <SqlWorkloadType>]
[-StorageConfigurationSettingDiskConfigurationType <DiskConfigurationType>]
[-StorageConfigurationSettingSqlSystemDbOnDataDisk]
[-StorageConfigurationSettingStorageWorkloadType <StorageWorkloadType>]
[-Tag <Hashtable>]
[-WsfcDomainCredentialsClusterBootstrapAccountPassword <SecureString>]
[-WsfcDomainCredentialsClusterOperatorAccountPassword <SecureString>]
[-WsfcDomainCredentialsSqlServiceAccountPassword <SecureString>]
[-WsfcStaticIP <String>]
[-DefaultProfile <PSObject>]
[-AsJob]
[-NoWait]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Description
Crea o actualiza una máquina virtual SQL.
Si va a actualizar una máquina virtual SQL existente y se omite un parámetro como -Tag, se pueden quitar los valores definidos anteriormente. Por este motivo, se recomienda usar Update-AzSqlVM para evitar sobrescribir parámetros no deseados.
Ejemplos
Ejemplo 1
New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus'
Location Name ResourceGroupName
-------- ---- -----------------
eastus sqlvm1 ResourceGroup01Cree una máquina virtual SQL con la configuración predeterminada.
Ejemplo 2
New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -Sku 'Developer' -LicenseType 'PAYG'
Location Name ResourceGroupName
-------- ---- -----------------
eastus sqlvm1 ResourceGroup01Cree una máquina virtual SQL con SKU y tipo de licencia específicos.
Ejemplo 3
New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -LicenseType 'AHUB'
Location Name ResourceGroupName
-------- ---- -----------------
eastus sqlvm1 ResourceGroup01Cree una máquina virtual SQL con la etiqueta de facturación de AHUB.
Ejemplo 4
New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -LicenseType 'DR'
Location Name ResourceGroupName
-------- ---- -----------------
eastus sqlvm1 ResourceGroup01Cree una máquina virtual SQL con la etiqueta de facturación de recuperación ante desastres.
Ejemplo 5
New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -AutoBackupSettingEnable `
-AutoBackupSettingBackupScheduleType manual -AutoBackupSettingFullBackupFrequency Weekly -AutoBackupSettingFullBackupStartTime 5 `
-AutoBackupSettingFullBackupWindowHour 2 -AutoBackupSettingStorageAccessKey 'keyvalue' -AutoBackupSettingStorageAccountUrl `
'https://storagename.blob.core.windows.net/' -AutoBackupSettingRetentionPeriod 10 -AutoBackupSettingLogBackupFrequency 60 `
-AutoBackupSettingStorageContainerName 'storagecontainername'
Location Name ResourceGroupName
-------- ---- -----------------
eastus sqlvm1 ResourceGroup01Cree una máquina virtual SQL y configure las opciones de copia de seguridad automática.
Ejemplo 6
New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -AutoPatchingSettingDayOfWeek Thursday `
-AutoPatchingSettingMaintenanceWindowDuration 120 -AutoPatchingSettingMaintenanceWindowStartingHour 3 -AutoPatchingSettingEnable
Location Name ResourceGroupName
-------- ---- -----------------
eastus sqlvm1 ResourceGroup01Cree una máquina virtual SQL y configure las opciones de aplicación de revisiones automáticas.
Ejemplo 7
New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -AssessmentSettingEnable
Location Name ResourceGroupName
-------- ---- -----------------
eastus sqlvm1 ResourceGroup01Cree una máquina virtual SQL y configure las opciones de evaluación.
Ejemplo 8
New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -AsJob
Location Name ResourceGroupName
-------- ---- -----------------
eastus sqlvm1 ResourceGroup01Cree una máquina virtual SQL como trabajo en segundo plano.
Parámetros
-AdditionalFeatureServerConfigurationIsRServicesEnabled
Habilite o deshabilite los servicios de R (SQL 2016 en adelante).
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AsJob
Ejecución del comando como trabajo
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AssessmentSettingEnable
Habilite o deshabilite la característica de evaluación de procedimientos recomendados de SQL en la máquina virtual SQL.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AssessmentSettingRunImmediately
Ejecute la evaluación de procedimientos recomendados de SQL inmediatamente en la máquina virtual sql.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingBackupScheduleType
Tipo de programación de copia de seguridad.
| Type: | BackupScheduleType |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingBackupSystemDb
Incluya o excluya las bases de datos del sistema de la copia de seguridad automática.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingDaysOfWeek
Días de la semana para las copias de seguridad cuando FullBackupFrequency está establecido en Weekly.
| Type: | AutoBackupDaysOfWeek[] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingEnable
Habilite o deshabilite la devolución de seguridad automática en la máquina virtual SQL.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingEnableEncryption
Habilite o deshabilite el cifrado para la copia de seguridad en la máquina virtual SQL.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingFullBackupFrequency
Frecuencia de las copias de seguridad completas. En ambos casos, las copias de seguridad completas se inician durante el siguiente período de tiempo programado.
| Type: | FullBackupFrequencyType |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingFullBackupStartTime
Hora de inicio de un día determinado durante el cual se pueden realizar copias de seguridad completas. 0-23 horas.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingFullBackupWindowHour
Duración del período de tiempo de un día determinado durante el cual se pueden realizar copias de seguridad completas. 1-23 horas.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingLogBackupFrequency
Frecuencia de las copias de seguridad de registros. 5-60 minutos.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingPassword
Contraseña para el cifrado en la copia de seguridad.
| Type: | SecureString |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingRetentionPeriod
Período de retención de la copia de seguridad: 1 a 90 días.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingStorageAccessKey
Clave de cuenta de almacenamiento en la que se realizará la copia de seguridad.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingStorageAccountUrl
Dirección URL de la cuenta de almacenamiento a la que se realizará la copia de seguridad.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoBackupSettingStorageContainerName
Nombre del contenedor de almacenamiento al que se realizará la copia de seguridad.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoPatchingSettingDayOfWeek
Día de la semana para aplicar la revisión.
| Type: | DayOfWeek |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoPatchingSettingEnable
Habilite o deshabilite el autopatching en la máquina virtual SQL.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoPatchingSettingMaintenanceWindowDuration
Duración de la aplicación de revisiones.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AutoPatchingSettingMaintenanceWindowStartingHour
Hora del día en que se inicia la aplicación de revisiones. Hora local de la máquina virtual.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-AzureAdAuthenticationSettingClientId
Identificador de cliente de la identidad administrada para consultar Microsoft Graph API. Se debe usar una cadena vacía para la identidad administrada asignada por el sistema.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Confirm
Le solicita su confirmación antes de ejecutar el cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DefaultProfile
Credenciales, cuenta, inquilino y suscripción usados para la comunicación con Azure.
| Type: | PSObject |
| Aliases: | AzureRMContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-EnableAutomaticUpgrade
Habilite la actualización automática del Agente de extensión iaaS de Sql.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-IdentityType
Tipo de identidad. Establézcalo en "SystemAssigned" para crear y asignar automáticamente una entidad de seguridad de Azure Active Directory para el recurso.
| Type: | IdentityType |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-KeyVaultCredentialSettingAzureKeyVaultUrl
Dirección URL de Azure Key Vault.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-KeyVaultCredentialSettingCredentialName
Nombre de credencial.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-KeyVaultCredentialSettingEnable
Habilite o deshabilite la configuración de credenciales del almacén de claves.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-KeyVaultCredentialSettingServicePrincipalName
Nombre de entidad de seguridad de servicio para acceder al almacén de claves.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-KeyVaultCredentialSettingServicePrincipalSecret
Secreto de nombre de entidad de seguridad de servicio para acceder al almacén de claves.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-LeastPrivilegeMode
Modo de privilegios mínimos del Agente IaaS de SQL.
| Type: | LeastPrivilegeMode |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-LicenseType
Tipo de licencia de SQL Server.
| Type: | SqlServerLicenseType |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Location
Ubicación de recursos.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Name
Nombre de la máquina virtual SQL.
| Type: | String |
| Aliases: | SqlVirtualMachineName, SqlVMName |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-NoWait
Ejecutar el comando de forma asincrónica
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Offer
Oferta de imagen de SQL. Algunos ejemplos son SQL2016-WS2016, SQL2017-WS2016.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ResourceGroupName
Nombre del grupo de recursos que contiene el recurso. Puede obtener este valor en la API del Administrador de recursos o el portal de Azure.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ScheduleDayOfWeek
Día de la semana para ejecutar la evaluación.
| Type: | AssessmentDayOfWeek |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ScheduleEnable
Habilite o deshabilite la programación de evaluación en la máquina virtual SQL.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ScheduleMonthlyOccurrence
Repetición del día DayOfWeek en un mes para programar la evaluación. Toma valores: 1,2,3,4 y -1. Usar -1 para el último día dayOfWeek del mes
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ScheduleStartTime
Hora del día en formato HH:mm. Eg. 17:30
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ScheduleWeeklyInterval
Número de semanas que se van a programar entre 2 ejecuciones de evaluación. Toma el valor de 1 a 6
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Sku
Tipo de edición de SQL Server.
| Type: | SqlImageSku |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlConnectivityUpdateSettingConnectivityType
Opción de conectividad de SQL Server.
| Type: | ConnectivityType |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlConnectivityUpdateSettingPort
Puerto de SQL Server.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlConnectivityUpdateSettingSqlAuthUpdatePassword
Contraseña de inicio de sesión sysadmin de SQL Server.
| Type: | SecureString |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlConnectivityUpdateSettingSqlAuthUpdateUserName
Inicio de sesión sysadmin de SQL Server que se va a crear.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlDataSettingDefaultFilePath
Ruta de acceso de archivo predeterminada de SQL Server
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlDataSettingLun
Números de unidad lógica para los discos.
| Type: | Int32[] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlInstanceSettingCollation
Intercalación de SQL Server.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlInstanceSettingIsIfiEnabled
IFI de SQL Server.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlInstanceSettingIsLpimEnabled
SQL Server LPIM.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlInstanceSettingIsOptimizeForAdHocWorkloadsEnabled
SQL Server Optimize for Adhoc workloads (Optimización de SQL Server para cargas de trabajo de Adhoc).
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlInstanceSettingMaxDop
SQL Server MAXDOP.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlInstanceSettingMaxServerMemoryMb
Memoria máxima de SQL Server.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlInstanceSettingMinServerMemoryMb
Memoria mínima de SQL Server.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlLogSettingDefaultFilePath
Ruta de acceso de archivo predeterminada de SQL Server
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlLogSettingLun
Números de unidad lógica para los discos.
| Type: | Int32[] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlManagementType
Tipo de administración de SQL Server.
| Type: | SqlManagementMode |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlStorageUpdateSettingDiskConfigurationType
Configuración de disco que se va a aplicar a SQL Server.
| Type: | DiskConfigurationType |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlStorageUpdateSettingDiskCount
Recuento de discos de máquina virtual.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlStorageUpdateSettingStartingDeviceId
Identificador de dispositivo del primer disco que se va a actualizar.
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlTempDbSettingDataFileCount
Recuento de archivos de datos tempdb de SQL Server
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlTempDbSettingDataFileSize
Tamaño del archivo de datos tempdb de SQL Server
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlTempDbSettingDataGrowth
Tamaño de crecimiento automático del archivo de datos tempdb de SQL Server
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlTempDbSettingDefaultFilePath
Ruta de acceso de archivo predeterminada de SQL Server
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlTempDbSettingLogFileSize
Tamaño del archivo de registro de tempdb de SQL Server
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlTempDbSettingLogGrowth
Tamaño de crecimiento automático del archivo de registro de tempdb de SQL Server
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlTempDbSettingLun
Números de unidad lógica para los discos.
| Type: | Int32[] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlTempDbSettingPersistFolder
Opción de carpeta persistente de tempdb de SQL Server
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlTempDbSettingPersistFolderPath
Ubicación de carpeta persistente de tempdb de SQL Server
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlVirtualMachineGroupResourceId
Identificador de recurso de ARM del grupo de máquinas virtuales SQL de la que forma parte esta máquina virtual SQL.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlWorkloadTypeUpdateSettingSqlWorkloadType
Tipo de carga de trabajo de SQL Server.
| Type: | SqlWorkloadType |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-StorageConfigurationSettingDiskConfigurationType
Configuración de disco que se va a aplicar a SQL Server.
| Type: | DiskConfigurationType |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-StorageConfigurationSettingSqlSystemDbOnDataDisk
Almacenamiento systemDb de SQL Server en DataPool si es true.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-StorageConfigurationSettingStorageWorkloadType
Tipo de carga de trabajo de almacenamiento.
| Type: | StorageWorkloadType |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SubscriptionId
Identificador de suscripción que identifica una suscripción de Azure.
| Type: | String |
| Position: | Named |
| Default value: | (Get-AzContext).Subscription.Id |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Tag
Etiquetas del recurso.
| Type: | Hashtable |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-WhatIf
Muestra lo que sucedería si se ejecutara el cmdlet. El cmdlet no se ejecuta.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-WsfcDomainCredentialsClusterBootstrapAccountPassword
Contraseña de la cuenta de arranque del clúster.
| Type: | SecureString |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-WsfcDomainCredentialsClusterOperatorAccountPassword
Contraseña de la cuenta del operador de clúster.
| Type: | SecureString |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-WsfcDomainCredentialsSqlServiceAccountPassword
Contraseña de la cuenta de servicio SQL.
| Type: | SecureString |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-WsfcStaticIP
Credenciales de dominio para configurar el clúster de conmutación por error de Windows Server para el grupo de disponibilidad de SQL.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Salidas
Comentarios
Próximamente: A lo largo de 2024 iremos eliminando gradualmente GitHub Issues como mecanismo de comentarios sobre el contenido y lo sustituiremos por un nuevo sistema de comentarios. Para más información, vea: https://aka.ms/ContentUserFeedback.
Enviar y ver comentarios de