Functions/function-Test-DatabaseExists.ps1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
function Test-DatabaseExists { <# .SYNOPSIS Checks if a database exists on a specified sql instance .DESCRIPTION Check to see if a database exists before restoring a database to make sure we don't clobber anything important. Also checks for system databases (master, model, msdb, temp) .EXAMPLE Test-DatabaseExists -RestoreSQLServer $sqlvr -DatabaseName $dbname .PARAMETER RestoreSQLServer A SQL server SMO connection object .PARAMETER DatabaseName Database Name to check #> [CmdletBinding()] param ( [Parameter(Mandatory=$True)] [String]$DatabaseName, [Parameter(Mandatory=$True)] [Microsoft.SqlServer.Management.Smo.SqlSmoObject]$RestoreSQLServer ) if ($RestoreSQLServer.Databases.Contains($DatabaseName)){ return $true } else { return $false } } |