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

BACKUPS IN AAG MULTI SITE CLUSTER Expand / Collapse
Author
Message
Posted Saturday, October 26, 2013 3:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 12, 2014 5:25 AM
Points: 4, Visits: 26
Hi All,
WE the following setup:
SQL server 2012 AAG : Node 1(Primary server) and Node 2(Secondary server) { Primary Location}, Node 3 (DR)
As of now we have configured system database backup on primary server and All database backup on (Node2) Primary location Secondary server.

Now my requirement is How to configure All databases backup on Node3( DR). I have create maintenance plan but only system databases are being backed up but not the User Databases.
Pls suggest me how to configure all databases backups on DR site.
Post #1508647
Posted Monday, October 28, 2013 5:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:25 AM
Points: 313, Visits: 584
What synchronisation method are you using for Node3 (DR)?

MCITP SQL 2005, MCSA SQL 2012
Post #1508808
Posted Tuesday, October 29, 2013 9:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 12, 2014 5:25 AM
Points: 4, Visits: 26
We are using async mode on DR site and on primary site both servers are in sync mode...
Post #1509443
Posted Tuesday, October 29, 2013 10:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:25 AM
Points: 313, Visits: 584
As the database(s) in the DR node are asynchronous it is a non readable secondary and for that reason its not possible to take a backup of the databases. Only active secondary's (synchronous) can be used for off loading backups.

MCITP SQL 2005, MCSA SQL 2012
Post #1509447
Posted Tuesday, October 29, 2013 10:13 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:25 AM
Points: 313, Visits: 584
Actually that last statement is partially incorrect, you cannot do it using a maintenance plan as the maintenance plan tools cannot read the database, but you can do it via scripts.


http://technet.microsoft.com/en-us/library/hh245119.aspx


MCITP SQL 2005, MCSA SQL 2012
Post #1509451
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse