dataplat
Restore-DbaDatabase Not Restoring Differential Backups When Using -MaintenanceSolutionBackup
Verified issue does not already exist?
I have searched and found no existing issue
What error did you receive?
No error is presented, but it's only using the latest full backup and not the latest diff backup.
Steps to Reproduce
# provide your command(s) executed pertaining to dbatools
# please include variable values (redacted or fake if needed) for reference
Backup SQL server doing a full and then a diff using Ola's scripts, and then try to do a restore with Restore-DbaDatabase using the -MaintenanceSolutionBackup switch.
Please confirm that you are running the most recent version of dbatools
1.1.71
Other details or mentions
NA
What PowerShell host was used when producing this error
Windows PowerShell ISE (powershell_ise.exe)
PowerShell Host Version
Name Value
PSVersion 5.1.14409.1027
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.14409.1027
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1
SQL Server Edition and Build number
Microsoft SQL Server 2017 (RTM-CU29) (KB5010786) - 14.0.3436.1 (X64) Mar 18 2022 13:21:03 Copyright (C) 2017 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: )
.NET Framework Version
.NET Framework 4.8.4526.0
Hello @SelectDBA, please show us exactly the code you're using, without the server name
Hi @potatoqualitee, thanks for your response. The code I am using is here:
Restore-DbaDatabase -SqlInstance $localHost -Path $_.FullName -MaintenanceSolutionBackup -IgnoreLogBackup
The variables in the script are: $localHost = "localhost" and $_.FullName = "\backuppath\servername\dbname" (i.e. default pathing from Ola)
I did a "what-if" on the script and got this (meaning its just looking at the full backup only):
What if: Performing the operation "Restoring dbname to servername based on these files: \backuppath\servername\dbname\FULL\servername_dbname_FULL_20220814_104321.bak" on target "servername".
I thought that may be the issue and can see how you got there. For this to work, point the Path to both the full and the diff backups. It'll read the headers, build your chain (even without the the MaintenanceSolutionBackup param) and both will install 👍🏼
Hi @potatoqualitee, thanks for the info. I may not be following though, sorry! I am pointing at the parent directory for the database, which contains both a "FULL" folder and a "DIFF" folder underneath it. As an example, the folder structure is \backup_path\server\database\FULL and \backup_path\server\database\DIFF, which is the default for Ola's scripts. Do you mean I should point at both of the FULL and DIFF folders individually? Its weird because using the parent folder (\backup_path\server\database) finds the full backups without issue.
Sure thing! That output is here:
VERBOSE: [15:56:57][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object VERBOSE: [15:56:57][Connect-DbaInstance] authentication method is 'local integrated' VERBOSE: [15:56:58][Restore-DbaDatabase] Changing statement timeout to infinity VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Restore-DbaDatabase] ParameterSet = Restore VERBOSE: [15:56:58][Restore-DbaDatabase] Unverified input, full scans - \backup_path\server\database VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Get-DbaBackupInformation] OLA - Getting folder contents VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Get-XpDirTreeRestoreFile] Enumerating subdirectory '\backup_path\server\database\FULL' VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Get-XpDirTreeRestoreFile] Enumerating subdirectory '\backup_path\server\database\DIFF' VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Get-DbaBackupInformation] Skipping Log Backups as requested VERBOSE: [15:56:58][Get-DbaBackupInformation] Reading backup headers of 33 files VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20210930_180002.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20211231_180002.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20220131_180003.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20220731_103030.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20220807_103053.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20220814_103046.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20210831_180004.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20201231_060110.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20211031_160001.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20211031_180014.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20211130_180005.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20220724_103015.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\FULL\SERVER_DATABASE_FULL_20191231_060038.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220630_163020.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220808_103040.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220813_103046.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220331_162835.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220809_103039.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220815_103100.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220228_162818.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220810_103039.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220816_103051.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20210831_160000.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220131_160001.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220531_162954.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220811_103057.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220817_103051.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20210930_160001.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20211130_160000.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220818_103034.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220812_103100.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220819_112656.bak} VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking: @{FullName=\backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20211231_160000.bak} VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Read-DbaBackupHeader] 33 unique files to scan. VERBOSE: [15:56:58][Read-DbaBackupHeader] Checking accessibility for all the files. VERBOSE: [15:56:58][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20210930_180002.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20211231_180002.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20220131_180003.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20220731_103030.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20220807_103053.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20220814_103046.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20210831_180004.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20201231_060110.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20211031_160001.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20211031_180014.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20211130_180005.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20220724_103015.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\FULL\SERVER_DATABASE_FULL_20191231_060038.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220630_163020.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220808_103040.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220813_103046.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220331_162835.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220809_103039.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220815_103100.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220228_162818.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220810_103039.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220816_103051.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20210831_160000.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220131_160001.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220531_162954.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220811_103057.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220817_103051.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20210930_160001.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20211130_160000.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220818_103034.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220812_103100.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20220819_112656.bak. VERBOSE: [15:56:58][Read-DbaBackupHeader] Scanning file \backup_path\server\database\DIFF\SERVER_DATABASE_DIFF_20211231_160000.bak. VERBOSE: [15:57:02][Restore-DbaDatabase] Processing DatabaseName - VERBOSE: [15:57:02][Format-DbaBackupInformation] Starting VERBOSE: [15:57:02][Format-DbaBackupInformation] String passed in for DB rename VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\DATAFILES\DATABASE.mdf VERBOSE: [15:57:02][Format-DbaBackupInformation] 1 PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Format-DbaBackupInformation] PhysicalName = X:\LOGFILES\DATABASE_log.ldf VERBOSE: [15:57:02][Select-DbaBackupInformation] processing diffs VERBOSE: [15:57:03][Select-DbaBackupInformation] Found LogBaseLsn: 4481000001904000001 and FirstRecoveryForkID: VERBOSE: [15:57:03][Restore-DbaDatabase] VerifyOnly = False VERBOSE: [15:57:03][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:57:03][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:57:03][Test-DbaBackupInformation] Testing restore for DATABASE VERBOSE: [15:57:03][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:57:03][Test-DbaBackupInformation] VerifyOnly = False VERBOSE: [15:57:03][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:57:03][Test-DbaLsnChain] Testing LSN Chain VERBOSE: [15:57:03][Test-DbaLsnChain] Testing LSN Chain - Type Type VERBOSE: [15:57:03][Test-DbaLsnChain] Passed LSN Chain checks VERBOSE: [15:57:03][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object VERBOSE: [15:57:03][Test-DbaBackupInformation] Marking DATABASE as verified VERBOSE: [15:57:03][Restore-DbaDatabase] DATABASE passed testing VERBOSE: [15:57:03][Restore-DbaDatabase] Passing in to restore VERBOSE: [15:57:03][Connect-DbaInstance] Server object passed in, will do some checks and then return the original object What if: Killing processes in DATABASE on SERVER as it exists and WithReplace specified
Hi. Looks like we're scanning the files ok, so could be a filtering issue. just to make sure, would it be possible to move a know pair of full and diff backs to another folder and then run the command against them?
