internal/functions/Get-DbaDbPhysicalFile.ps1
|
function Get-DbaDbPhysicalFile { <# .SYNOPSIS Gets raw information about physical files linked to databases .DESCRIPTION Fastest way to fetch just the paths of the physical files for every database on the instance, also for offline databases. Incidentally, it also fetches the paths for MMO and FS filegroups. This is partly already in Get-DbaDbFile, but this internal needs to stay lean and fast, as it's heavily used in top-level functions .PARAMETER SqlInstance SMO object representing the SQL Server to connect to. .EXAMPLE Get-DbaDbPhysicalFile -SqlInstance server1\instance2 .NOTES Author: Simone Bizzotto dbatools PowerShell module (https://dbatools.io, clemaire@gmail.com) Copyright: (c) 2018 by dbatools, licensed under MIT License: MIT https://opensource.org/licenses/MIT #> [CmdletBinding()] param( [parameter(Mandatory)] [Alias("ServerInstance", "SqlServer")] [DbaInstanceParameter]$SqlInstance, [Alias("Credential")] [PSCredential] $SqlCredential ) try { $Server = Connect-SqlInstance -SqlInstance $SqlInstance -SqlCredential $SqlCredential } catch { Stop-Function -Message "Failure" -Category ConnectionError -ErrorRecord $_ -Target $SqlInstance return } if ($Server.versionMajor -le 8) { $sql = "SELECT DB_NAME(dbid) AS Name, filename AS PhysicalName FROM sysaltfiles" } else { $sql = "SELECT DB_NAME(database_id) AS Name, physical_name AS PhysicalName FROM sys.master_files" } Write-Message -Level Debug -Message "$sql" try { $Server.Query($sql) } catch { throw "Error enumerating files" } } |