Unfortunately I get:
“No backups for “database xxx” found in “\xxx\xxx$\…”
as soon as I add the @StopAt = ‘2019-03-27T04:05:20 Parameter.
When I comment this Parameter, everything works fine, except that only the 1st logfile after the full backup gets restored – and not all log Backups in the same backup Directory.
Also tried with the date Format in the scripts example: @StopAt = 20192703040520, but I get same error. What am I doing wrong ? Name of Backup files (trn) is like this: tools_backup_2019_03_27_110112_9746376.trn
Help appreciated :-).
added 28032019:
First of all thanks for your answers so far !!!
ms sql version: 2016 standard (13.0.5216.0)
@StopAt = '20190328100000', (set to correct format ? server default language is: german !
this query on same sql db server:
SELECT SYSDATETIME()
,SYSDATETIMEOFFSET()
,SYSUTCDATETIME()
,CURRENT_TIMESTAMP
,GETDATE()
,GETUTCDATE();
gives this result:
2019-03-28 16:10:22.8098949
2019-03-28 16:10:22.8098949 +01:00
2019-03-28 15:10:22.8098949
2019-03-28 16:10:22.807
2019-03-28 16:10:22.807
2019-03-28 15:10:22.807
My goal is to restore "point in time" to march, 28th, 10 am
exact statement:
EXEC dbo.sp_DatabaseRestore
@Database = 'tools',
@BackupPathFull = '\dicvm.de\backupsql$\SV10RXVDB24\tools',
@BackupPathDiff = '\dicvm.de\backupsql$\SV10RXVDB24\tools',
@BackupPathLog = '\dicvm.de\backupsql$\SV10RXVDB24\tools',
@RestoreDiff = 0,
@ContinueLogs = 1,
@RunRecovery = 1,
@TestRestore = 0,
@StopAt = '20190328100000',
@RunCheckDB = 0,
@Debug = 1,
@help = 0,
@Execute = 'N';
...changing setting for @ContinueLogs, @RunRecovery or @Execute doesn't change anything, error (still):
Nachricht 50000, Stufe 16, Status 1, Prozedur sp_DatabaseRestore, Zeile 486 [Batchstartzeile 0]
No backups for "tools" found in "\dicvm.de\backupsql$\SV10RXVDB24\tools"
files in @BackupPathFull directory are as follows (full- and log-Backups only, no diff Backups):
Verzeichnis von \dicvm.de\backupsql$\SV10RXVDB24\tools
28.03.2019 11:01 .
28.03.2019 11:01 ..
27.03.2019 05:01 14.848 tools_backup_2019_03_27_050103_2371617.trn
27.03.2019 11:01 13.824 tools_backup_2019_03_27_110112_9746376.trn
27.03.2019 17:01 9.728 tools_backup_2019_03_27_170102_2790723.trn
27.03.2019 22:01 1.297.920 tools_backup_2019_03_27_220002_2539287.bak
27.03.2019 23:01 14.336 tools_backup_2019_03_27_230102_5656503.trn
28.03.2019 05:01 13.312 tools_backup_2019_03_28_050103_8892863.trn
28.03.2019 11:01 12.800 tools_backup_2019_03_28_110103_0664649.trn
@laughingVergil: So I assume there is a full backup - earlier than the @StopAt parameter's time as of 27.03.2019 22:01 - in the target directory (?)
And: Yes: Your assumption is right: I am using Brent Ozar's First Responder Kit in the newest version.
Thanks again, your answers are appreciated very much !
cheers, Michael
