none
How to recover a database participating in AOAG, when the cluster is down?

    Question

  • Without getting the cluster up/online, how a database participating in an AOAG can be brought online?

    yup

    Sunday, June 30, 2013 10:46 AM

All replies

  • Hello,

    Did you means how secondary database be brought online during failover on  availability group?

    An availability group supports a primary databases and one to four sets of corresponding secondary databases.
    In data synchronization process, which occurs at the database level,The primary replica sends transaction log records of each primary database to every secondary database. Every secondary replica caches the transaction log records (hardens the log) and then applies them to its corresponding secondary database.

    During the failover, the failover target takes over the primary role, recovers its databases, and brings them online as the new primary databases. Failovers are not caused by database issues such as a database becoming suspect due to a loss of a data file or corruption of a transaction log. However, there may be data loss basd on the failover mode.

    Reference:http://msdn.microsoft.com/en-us/library/ff877884.aspx

    Regards,
    Fanny Liu

    If you have any feedback on our support, please click  here.


    Fanny Liu
    TechNet Community Support



    Monday, July 01, 2013 5:34 AM
    Moderator
  • Do you mean both nodes within a clustering is down? Do you have backups... Copy the backups and start SQL Server on another machine and restore the db.

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

    Monday, July 01, 2013 5:54 AM
  • This is for a scenario when the cluster service is down, nodes are still up & running & the SQL service is available.


    yup

    Monday, July 01, 2013 6:02 AM
  • Hmm, can you provide me with step by step how shut down the cluster service but having MSSQL Service up?

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

    Monday, July 01, 2013 9:01 AM
  • This is an AOAG setup where two win 6.1 hosts running standalone sql instances are participating in an Availability Group. What I did was from CluAdmin --> shutdown the cluster.

    yup

    Monday, July 01, 2013 9:10 AM
  • You cannot remove the Availability Group without the Windows Server Failover Cluster (WSFC). Availability Group is dependent on it. That's why if your Availability Group becomes unavailable due to a quorum issue, you need to 

    1. force start the WSFC without a quorum,
    2. remove the databases from the Availability Group and
    3. recover the databases in the secondary replicas.

    If the SQL Server instances are still online even when the Availability Group is offline, you can still access the databases using the instance name


    Edwin Sarmiento SQL Server MVP
    Blog | Twitter | LinkedIn

    Monday, July 01, 2013 11:10 PM
    Moderator
  • Is there a way to get the database(s) up & running on the promary itself, because one the cluster is down the listener wount be working any more & lets say the secondary lost its sync sometime before the cluster went down. Now the primary has the most updated data. How to get the databases on the primary up?

    yup

    Tuesday, July 02, 2013 3:15 AM