deleted_servers

Creates, updates, deletes, gets or lists a deleted_servers resource.

Overview

Name	deleted_servers
Type	Resource
Id	azure.sql.deleted_servers

Fields

vw_deleted_servers

Name	Datatype	Description
deletedServerName	text	field from the properties object
deletion_time	text	field from the properties object
fully_qualified_domain_name	text	field from the properties object
locationName	text	field from the properties object
original_id	text	field from the properties object
subscriptionId	text	field from the properties object
version	text	field from the properties object

deleted_servers

Name	Datatype	Description
properties	object	The properties of a deleted server.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	deletedServerName, locationName, subscriptionId	Gets a deleted server.
list	SELECT	subscriptionId	Gets a list of all deleted servers in a subscription.
list_by_location	SELECT	locationName, subscriptionId	Gets a list of deleted servers for a location.
recover	EXEC	deletedServerName, locationName, subscriptionId	Recovers a deleted server.

SELECT examples

Gets a list of all deleted servers in a subscription.

vw_deleted_servers

SELECT
deletedServerName,
deletion_time,
fully_qualified_domain_name,
locationName,
original_id,
subscriptionId,
version
FROM azure.sql.vw_deleted_servers
WHERE subscriptionId = '{{ subscriptionId }}';

deleted_servers

SELECT
properties
FROM azure.sql.deleted_servers
WHERE subscriptionId = '{{ subscriptionId }}';