internal/Get-RestoreContinuableDatabase.ps1
|
function Get-RestoreContinuableDatabase { <# .SYNOPSIS Gets a list of databases from a SQL instance that are in a state for further restores .DESCRIPTION Takes a SQL instance and checks for databases with a redo_start_lsn value, and returns the database name and that value -gt SQl 2005 it comes from master.sys.master_files -eq SQL 2000 DBCC DBINFO #> [CmdletBinding()] Param ( [parameter(Mandatory = $true, ValueFromPipeline = $true)] [object]$SqlInstance, [PSCredential]$SqlCredential, [switch][Alias('Silent')]$EnableException ) try { $Server = Connect-SqlInstance -Sqlinstance $SqlInstance -SqlCredential $SqlCredential } catch { Write-Warning "$FunctionName - Cannot connect to $SqlInstance" break } if ($Server.VersionMajor -ge 9) { $sql = "select db_name(database_id) as 'Database', redo_start_lsn, redo_start_fork_guid as 'FirstRecoveryForkID' from master.sys.master_files where redo_start_lsn is not NULL" } else { $sql =" CREATE TABLE #db_info ( ParentObject NVARCHAR(128) COLLATE database_default , Object NVARCHAR(128) COLLATE database_default, Field NVARCHAR(128) COLLATE database_default, Value SQL_VARIANT )" } $server.ConnectionContext.ExecuteWithResults($sql).Tables.Rows } |