Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Azure Native v2
  3. API Docs
  4. azurearcdata
  5. getSqlServerDatabase
These are the docs for Azure Native v2. We recommenend using the latest version, Azure Native v3.
Azure Native v2 v2.90.0 published on Thursday, Mar 27, 2025 by Pulumi
pulumi/pulumi-azure-native

azure-native-v2.azurearcdata.getSqlServerDatabase

Explore with Pulumi AI

These are the docs for Azure Native v2. We recommenend using the latest version, Azure Native v3.
Azure Native v2 v2.90.0 published on Thursday, Mar 27, 2025 by Pulumi
pulumi/pulumi-azure-native

Retrieves an Arc Sql Server database. Azure REST API version: 2023-01-15-preview.

Other available API versions: 2024-01-01, 2024-05-01-preview.

Using getSqlServerDatabase

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getSqlServerDatabase(args: GetSqlServerDatabaseArgs, opts?: InvokeOptions): Promise<GetSqlServerDatabaseResult>
function getSqlServerDatabaseOutput(args: GetSqlServerDatabaseOutputArgs, opts?: InvokeOptions): Output<GetSqlServerDatabaseResult>
Copy
def get_sql_server_database(database_name: Optional[str] = None,
                            resource_group_name: Optional[str] = None,
                            sql_server_instance_name: Optional[str] = None,
                            opts: Optional[InvokeOptions] = None) -> GetSqlServerDatabaseResult
def get_sql_server_database_output(database_name: Optional[pulumi.Input[str]] = None,
                            resource_group_name: Optional[pulumi.Input[str]] = None,
                            sql_server_instance_name: Optional[pulumi.Input[str]] = None,
                            opts: Optional[InvokeOptions] = None) -> Output[GetSqlServerDatabaseResult]
Copy
func LookupSqlServerDatabase(ctx *Context, args *LookupSqlServerDatabaseArgs, opts ...InvokeOption) (*LookupSqlServerDatabaseResult, error)
func LookupSqlServerDatabaseOutput(ctx *Context, args *LookupSqlServerDatabaseOutputArgs, opts ...InvokeOption) LookupSqlServerDatabaseResultOutput
Copy

> Note: This function is named LookupSqlServerDatabase in the Go SDK.

public static class GetSqlServerDatabase 
{
    public static Task<GetSqlServerDatabaseResult> InvokeAsync(GetSqlServerDatabaseArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlServerDatabaseResult> Invoke(GetSqlServerDatabaseInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetSqlServerDatabaseResult> getSqlServerDatabase(GetSqlServerDatabaseArgs args, InvokeOptions options)
public static Output<GetSqlServerDatabaseResult> getSqlServerDatabase(GetSqlServerDatabaseArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: azure-native:azurearcdata:getSqlServerDatabase
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

DatabaseName
This property is required.
Changes to this property will trigger replacement.
string
Name of the database
ResourceGroupName
This property is required.
Changes to this property will trigger replacement.
string
The name of the Azure resource group
SqlServerInstanceName
This property is required.
Changes to this property will trigger replacement.
string
Name of SQL Server Instance
DatabaseName
This property is required.
Changes to this property will trigger replacement.
string
Name of the database
ResourceGroupName
This property is required.
Changes to this property will trigger replacement.
string
The name of the Azure resource group
SqlServerInstanceName
This property is required.
Changes to this property will trigger replacement.
string
Name of SQL Server Instance
databaseName
This property is required.
Changes to this property will trigger replacement.
String
Name of the database
resourceGroupName
This property is required.
Changes to this property will trigger replacement.
String
The name of the Azure resource group
sqlServerInstanceName
This property is required.
Changes to this property will trigger replacement.
String
Name of SQL Server Instance
databaseName
This property is required.
Changes to this property will trigger replacement.
string
Name of the database
resourceGroupName
This property is required.
Changes to this property will trigger replacement.
string
The name of the Azure resource group
sqlServerInstanceName
This property is required.
Changes to this property will trigger replacement.
string
Name of SQL Server Instance
database_name
This property is required.
Changes to this property will trigger replacement.
str
Name of the database
resource_group_name
This property is required.
Changes to this property will trigger replacement.
str
The name of the Azure resource group
sql_server_instance_name
This property is required.
Changes to this property will trigger replacement.
str
Name of SQL Server Instance
databaseName
This property is required.
Changes to this property will trigger replacement.
String
Name of the database
resourceGroupName
This property is required.
Changes to this property will trigger replacement.
String
The name of the Azure resource group
sqlServerInstanceName
This property is required.
Changes to this property will trigger replacement.
String
Name of SQL Server Instance

getSqlServerDatabase Result

The following output properties are available:

Id string
Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
Location string
The geo-location where the resource lives
Name string
The name of the resource
Properties Pulumi.AzureNative.AzureArcData.Outputs.SqlServerDatabaseResourcePropertiesResponse
Properties of Arc Sql Server database
SystemData Pulumi.AzureNative.AzureArcData.Outputs.SystemDataResponse
Azure Resource Manager metadata containing createdBy and modifiedBy information.
Type string
The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
Tags Dictionary<string, string>
Resource tags.
Id string
Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
Location string
The geo-location where the resource lives
Name string
The name of the resource
Properties SqlServerDatabaseResourcePropertiesResponse
Properties of Arc Sql Server database
SystemData SystemDataResponse
Azure Resource Manager metadata containing createdBy and modifiedBy information.
Type string
The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
Tags map[string]string
Resource tags.
id String
Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
location String
The geo-location where the resource lives
name String
The name of the resource
properties SqlServerDatabaseResourcePropertiesResponse
Properties of Arc Sql Server database
systemData SystemDataResponse
Azure Resource Manager metadata containing createdBy and modifiedBy information.
type String
The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
tags Map<String,String>
Resource tags.
id string
Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
location string
The geo-location where the resource lives
name string
The name of the resource
properties SqlServerDatabaseResourcePropertiesResponse
Properties of Arc Sql Server database
systemData SystemDataResponse
Azure Resource Manager metadata containing createdBy and modifiedBy information.
type string
The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
tags {[key: string]: string}
Resource tags.
id str
Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
location str
The geo-location where the resource lives
name str
The name of the resource
properties SqlServerDatabaseResourcePropertiesResponse
Properties of Arc Sql Server database
system_data SystemDataResponse
Azure Resource Manager metadata containing createdBy and modifiedBy information.
type str
The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
tags Mapping[str, str]
Resource tags.
id String
Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
location String
The geo-location where the resource lives
name String
The name of the resource
properties Property Map
Properties of Arc Sql Server database
systemData Property Map
Azure Resource Manager metadata containing createdBy and modifiedBy information.
type String
The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
tags Map<String>
Resource tags.

Supporting Types

SqlServerDatabaseResourcePropertiesResponse

ProvisioningState This property is required. string
The provisioning state of the Arc-enabled SQL Server database resource.
BackupInformation Pulumi.AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesResponseBackupInformation
CollationName string
Collation of the database.
CompatibilityLevel int
Compatibility level of the database
DatabaseCreationDate string
Creation date of the database.
DatabaseOptions Pulumi.AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesResponseDatabaseOptions
List of features that are enabled for the database
IsReadOnly bool
Whether the database is read only or not.
RecoveryMode string
Status of the database.
SizeMB double
Size of the database.
SpaceAvailableMB double
Space left of the database.
State string
State of the database.
ProvisioningState This property is required. string
The provisioning state of the Arc-enabled SQL Server database resource.
BackupInformation SqlServerDatabaseResourcePropertiesResponseBackupInformation
CollationName string
Collation of the database.
CompatibilityLevel int
Compatibility level of the database
DatabaseCreationDate string
Creation date of the database.
DatabaseOptions SqlServerDatabaseResourcePropertiesResponseDatabaseOptions
List of features that are enabled for the database
IsReadOnly bool
Whether the database is read only or not.
RecoveryMode string
Status of the database.
SizeMB float64
Size of the database.
SpaceAvailableMB float64
Space left of the database.
State string
State of the database.
provisioningState This property is required. String
The provisioning state of the Arc-enabled SQL Server database resource.
backupInformation SqlServerDatabaseResourcePropertiesResponseBackupInformation
collationName String
Collation of the database.
compatibilityLevel Integer
Compatibility level of the database
databaseCreationDate String
Creation date of the database.
databaseOptions SqlServerDatabaseResourcePropertiesResponseDatabaseOptions
List of features that are enabled for the database
isReadOnly Boolean
Whether the database is read only or not.
recoveryMode String
Status of the database.
sizeMB Double
Size of the database.
spaceAvailableMB Double
Space left of the database.
state String
State of the database.
provisioningState This property is required. string
The provisioning state of the Arc-enabled SQL Server database resource.
backupInformation SqlServerDatabaseResourcePropertiesResponseBackupInformation
collationName string
Collation of the database.
compatibilityLevel number
Compatibility level of the database
databaseCreationDate string
Creation date of the database.
databaseOptions SqlServerDatabaseResourcePropertiesResponseDatabaseOptions
List of features that are enabled for the database
isReadOnly boolean
Whether the database is read only or not.
recoveryMode string
Status of the database.
sizeMB number
Size of the database.
spaceAvailableMB number
Space left of the database.
state string
State of the database.
provisioning_state This property is required. str
The provisioning state of the Arc-enabled SQL Server database resource.
backup_information SqlServerDatabaseResourcePropertiesResponseBackupInformation
collation_name str
Collation of the database.
compatibility_level int
Compatibility level of the database
database_creation_date str
Creation date of the database.
database_options SqlServerDatabaseResourcePropertiesResponseDatabaseOptions
List of features that are enabled for the database
is_read_only bool
Whether the database is read only or not.
recovery_mode str
Status of the database.
size_mb float
Size of the database.
space_available_mb float
Space left of the database.
state str
State of the database.
provisioningState This property is required. String
The provisioning state of the Arc-enabled SQL Server database resource.
backupInformation Property Map
collationName String
Collation of the database.
compatibilityLevel Number
Compatibility level of the database
databaseCreationDate String
Creation date of the database.
databaseOptions Property Map
List of features that are enabled for the database
isReadOnly Boolean
Whether the database is read only or not.
recoveryMode String
Status of the database.
sizeMB Number
Size of the database.
spaceAvailableMB Number
Space left of the database.
state String
State of the database.

SqlServerDatabaseResourcePropertiesResponseBackupInformation

LastFullBackup string
Date time of last full backup.
LastLogBackup string
Date time of last log backup.
LastFullBackup string
Date time of last full backup.
LastLogBackup string
Date time of last log backup.
lastFullBackup String
Date time of last full backup.
lastLogBackup String
Date time of last log backup.
lastFullBackup string
Date time of last full backup.
lastLogBackup string
Date time of last log backup.
last_full_backup str
Date time of last full backup.
last_log_backup str
Date time of last log backup.
lastFullBackup String
Date time of last full backup.
lastLogBackup String
Date time of last log backup.

SqlServerDatabaseResourcePropertiesResponseDatabaseOptions

SystemDataResponse

CreatedAt string
The timestamp of resource creation (UTC).
CreatedBy string
The identity that created the resource.
CreatedByType string
The type of identity that created the resource.
LastModifiedAt string
The timestamp of resource last modification (UTC)
LastModifiedBy string
The identity that last modified the resource.
LastModifiedByType string
The type of identity that last modified the resource.
CreatedAt string
The timestamp of resource creation (UTC).
CreatedBy string
The identity that created the resource.
CreatedByType string
The type of identity that created the resource.
LastModifiedAt string
The timestamp of resource last modification (UTC)
LastModifiedBy string
The identity that last modified the resource.
LastModifiedByType string
The type of identity that last modified the resource.
createdAt String
The timestamp of resource creation (UTC).
createdBy String
The identity that created the resource.
createdByType String
The type of identity that created the resource.
lastModifiedAt String
The timestamp of resource last modification (UTC)
lastModifiedBy String
The identity that last modified the resource.
lastModifiedByType String
The type of identity that last modified the resource.
createdAt string
The timestamp of resource creation (UTC).
createdBy string
The identity that created the resource.
createdByType string
The type of identity that created the resource.
lastModifiedAt string
The timestamp of resource last modification (UTC)
lastModifiedBy string
The identity that last modified the resource.
lastModifiedByType string
The type of identity that last modified the resource.
created_at str
The timestamp of resource creation (UTC).
created_by str
The identity that created the resource.
created_by_type str
The type of identity that created the resource.
last_modified_at str
The timestamp of resource last modification (UTC)
last_modified_by str
The identity that last modified the resource.
last_modified_by_type str
The type of identity that last modified the resource.
createdAt String
The timestamp of resource creation (UTC).
createdBy String
The identity that created the resource.
createdByType String
The type of identity that created the resource.
lastModifiedAt String
The timestamp of resource last modification (UTC)
lastModifiedBy String
The identity that last modified the resource.
lastModifiedByType String
The type of identity that last modified the resource.

Package Details

Repository
azure-native-v2 pulumi/pulumi-azure-native
License
Apache-2.0
These are the docs for Azure Native v2. We recommenend using the latest version, Azure Native v3.
Azure Native v2 v2.90.0 published on Thursday, Mar 27, 2025 by Pulumi
pulumi/pulumi-azure-native