A modification on a great restore roll-up for MSDB, diffs+quotename+replace filename

May 6, 08:18 AM

I found a great script awhile ago on MSSQLTIPS by Greg Robidoux called Auto generate SQL Server database restore scripts and I noticed it didnt take into account differential backups. Here is my simple addition which adds that functionality: While it seems simple, this can be a very useful script if you have a series of full/diff/tlogs and want to quickly do one off restores.
Constantine Kokkinos