Assume that my mdf file is deleted and I set my database into single user mode. The first thing that I do is take tail log backup. My question is do I need to add NORECOVERY option while taking tail log backup? if so, then why? My point of view is if my db is set into single user mode which means that no one except me accessing database, then I can omit writing NORECOVERY as the main function of this keyword is to stop the subsequent transactions.
I would like ask the same question about NO_TRUNCATE keyword. As I know, when we take t-log backup (in full recovery model) we actually truncate t-log file and by writing NO_TRUNCATE keyword, SQL Server will not truncate t-log file after backup. Why do I need to keep that inactive part when I have already taken tail-log backup successfully?