Disasterrecovery

Test-DbaDbRecoveryModel

Claudio Silva (@ClaudioESSilva)

Test-DbaDbRecoveryModel View Source Claudio Silva (@ClaudioESSilva) Windows, Linux, macOS Synopsis Validates whether databases are truly operating in their configured recovery model Description When you switch a database into FULL recovery model, it will behave like a SIMPLE recovery model until a full backup is taken in order to begin a log backup chain. This function identifies the gap between configured and actual recovery model behavior. For FULL recovery databases, the function checks if a log backup chain has been established by examining the last_log_backup_lsn in sys.

Test-DbaLastBackup

Chrissy LeMaire (@cl), netnerds.net

Test-DbaLastBackup View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Quickly and easily tests the last set of full backups for a server. Description Restores all or some of the latest backups and performs a DBCC CHECKDB. Gathers information about the last full backups Restores the backups to the Destination with a new name. If no Destination is specified, the originating SQL Server instance wil be used. The database is restored as “dbatools-testrestore-$databaseName” by default, but you can change dbatools-testrestore to whatever you would like using -Prefix The internal file names are also renamed to prevent conflicts with original database A DBCC CHECKDB is then performed And the test database is finally dropped Syntax Test-DbaLastBackup [[-SqlInstance] <DbaInstanceParameter[]>] [[-SqlCredential] <PSCredential>] [[-Database] <Object[]>] [[-ExcludeDatabase] <Object[]>] [[-Destination] <DbaInstanceParameter>] [[-DestinationSqlCredential] <Object>] [[-DataDirectory] <String>] [[-LogDirectory] <String>] [[-FileStreamDirectory] <String>] [[-Prefix] <String>] [-VerifyOnly] [-NoCheck] [-NoDrop] [-CopyFile] [[-CopyPath] <String>] [[-MaxSize] <Int32>] [[-DeviceType] <String[]>] [-IncludeCopyOnly] [-IgnoreLogBackup] [[-AzureCredential] <String>] [[-InputObject] <Database[]>] [[-MaxTransferSize] <Int32>] [[-BufferCount] <Int32>] [-IgnoreDiffBackup] [[-MaxDop] <Int32>] [-ReuseSourceFolderStructure] [-EnableException] [-WhatIf] [-Confirm] [<CommonParameters>] Examples Example: 1 PS C:\> Test-DbaLastBackup -SqlInstance sql2016 Determines the last full backup for ALL databases, attempts to restore all databases (with a different name and file structure), then performs a DBCC CHECKDB.

New Release - Snowball - All About the Restore

Stuart

Just to confuse people, it’s not Chrissy or Drew this time. My name’s Stuart, and I’ve got a new dbatools release to tell you about; snowball. This Release Is All About Restores DBAs spend a lot of time making sure backups work. Or at least they should, and if they aren’t then putting their spare time to fixing up their CV is probably a good plan. So we’ve got terabytes of SQL backups stashed away on disk.