Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Why is backup allowed on standby database Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 12:08 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:18 AM
Points: 90, Visits: 135
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.
Post #1498526
Posted Wednesday, September 25, 2013 7:37 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 19, 2014 9:11 AM
Points: 417, Visits: 2,555
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.
Post #1498645
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse