Restoring a database on the passive cluster - is it possible? RRS feed

  • Question

  • We have a database we need to restore and we plan to place it outside our AGs so it would need to be restored on both the active and passive cluster. Is this possible? I've read something about being "shared" on SANS so you don't have to "restore" but you can't use SSIS because SSIS is not cluster-aware. Are there any articles or white papers out there that might clarify how to automate the restore of the database on the SQL Cluster.

    We are running SQL Server 2012.



    Friday, February 13, 2015 9:41 PM


  • Yes, there is no problem to restore the database.... 

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

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Marked as answer by OutThere Monday, February 23, 2015 2:36 PM
    Thursday, February 19, 2015 6:43 AM
  • Hi,

    Do you have FCI (Failover cluster instance) as well as AG?

    Where do you exactly want to restore the database?

    If you only have AG, then yes you can restore on the primary as well as secondary outside the AG as well.

    If you are refferring about FCI then no, you can only restore on the active node, there wont be any instance on passive.

    If you could give a clear example with name for nodes, ag etc etc and what exactly you are trying to achieve it would be helpfull to give suggestions.

    Also what kind of automatic restore are you looking for? If once a day overnight is enough you can just schedule a job which restores the backup using tsql script.

    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by OutThere Monday, February 23, 2015 2:36 PM
    Thursday, February 19, 2015 9:11 AM

All replies