• anoop.mig29 (9/25/2013)


    Hi friends

    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.

    Regards,
    SQLisAwe5oMe.