Initially I coded Restore Database in a TRY CATCH BLOCK.
The ERROR_MESSAGE() is collecting/showing the "RESTORE DATABASE is terminating abnormally".
When I execute Restore Database command in managmenet studio I get these following messages.
Msg 3257, Level 16, State 1, Line 1
There is insufficient free space on disk volume 'D:\' to create the database. The database requires 73002319872 additional free bytes, while only 67640401920 bytes are available.
Msg 3119, Level 16, State 4, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
How do I collect all the three messages in TSQL in CATCH BLOCK.