i know this is stupid question but i wanted to know why isn`t backup allowed on database that are in restoring mode or that are in standby mode.
Why when database is in standby mode it is written standby and readable
I heard that in 2012 database which are in standby mode or restoring mode , backups are allowed.if true why difference.
That's how it was designed, when db is in restoring/standby mode, you are not able to make any changes.....since its for DR purpose.
However, in 2012, with the design of alwayson availability groups, they have changed this design.