September 5, 2018 at 10:35 am
I lost 2 of the 3 node cluster , how do i recovery database that is in recovery pending. AD/DNS/Qouram share are not available
September 5, 2018 at 10:59 am
goher2000 - Wednesday, September 5, 2018 10:35 AMI lost 2 of the 3 node cluster , how do i recovery database that is in recovery pending. AD/DNS/Qouram share are not available
If all of the database files are available, you can try using alter database...set online
Sue
September 5, 2018 at 1:49 pm
here is how i recovered.
started cluster with forced quoram (https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/hh270275(v=sql.110)), changed it to no quoram, deleted server roles in cluster i.e. AG groups , ran 'restore database' and wola.... databases recovered.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply