sp_RestoreScript: full backup filename is followed by '0' (zero) character

SQLUndercover / UndercoverToolbox

A collection of cool and useful tools, procedures and scripts for the discerning DBA

https://sqlundercover.com

MIT License

84 stars 40 forks source link

Closed rubaboo closed 2 years ago

rubaboo commented 3 years ago

Describe the bug Generated script has an extraneous 0 (zero) character after the full backup filename. No zero after a log backup filename.

To Reproduce Run sp_RestoreScript. Observe the command … FROM DISK = '…\filename.bak'0 WITH NORECOVERY…

Additional context Latest version sp_RestoreScript 1.8

UndercoverDavid commented 3 years ago

Thanks for raising this, I'll have a look into it.

rubaboo commented 2 years ago