Get-DBPathInfo

Get-DBPathInfo

Infer values for server and database from SQLSERVER: drive.

Get-DBPathInfo [<CommonParameters>]

Infers the server instance and database from the current location or, if not on a SQL Server drive, then from the default SQLSERVER: drive. It extends the notion of default context. That is, you do not actually have to be on the SQLSERVER: drive, only to have set the current location on that drive to a server and database path.

<CommonParameters>

        This cmdlet supports the common parameters: Verbose, Debug,

        ErrorAction, ErrorVariable, WarningAction, WarningVariable,

        OutBuffer and OutVariable. For more information, see 

        about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216). 

None. You cannot pipe objects to Get-DBPathInfo.

Two-element array: first element contains server and instance name; second element contains database name.

        This function is part of the CleanCode toolbox

        from http://cleancode.sourceforge.net/.

        Since CleanCode 1.1.05.

-------------------------- EXAMPLE 1 --------------------------

C:\PS>($serverCandidate, $dbCandidate) = Get-DBPathInfo

If your current location is *not* on a SQLSERVER: drive or alias, then the current location of the SQLSERVER: drive is used as the reference location. If your current location includes the SQLSERVER: drive or an alias to some node on it, that is the reference location. Either way, the reference location is examined to see if it contains a server and/or database. If either server or db are both are not found $null is returned for that item.