does this help ??

-- choose database or currently used database will be selected
DECLARE @db_name VARCHAR(100)
SELECT @db_name = DB_NAME()

-- Get Backup History...

make sure the following
3434 tcp & udp ports are enabled between nodes.. 
135 tcp rpc port is open between  nodes
137 udp port open between nodes
49152 -...

b4 u begin, make sure apps are not using depreciated features.

check it , if job is created via mant. plan

check ag group properties

i will make it easy for you to test

# see what you have so you can revert

Get-ClusterResource | where-object {$_.ResourceType.name -eq "IP Address"} | Get-ClusterParameter...

there use to be command to pin table in memory not any more..

want to jump in deep?

Use DATABASE_NAME
GO
SELECT
name AS TableName,
IndexName,
IndexTypeDesc,
(cast(COUNT(*) as decimal(20,2)) *8.0)/1024 AS 'cached_page_Size(mb)',
COUNT(*) AS 'cached_pages_count'

try this

begin
DECLARE @Domain NVARCHAR(100)
EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE', 'SYSTEM\CurrentControlSet\services\Tcpip\Parameters', N'Domain',@Domain OUTPUT
--SELECT Cast(SERVERPROPERTY('MachineName') as nvarchar) + '.' + @Domain AS FQDN
declare @port nvarchar(100)
declare @auth...

I think its depends on usage of the database, i.e. how and how much application is using database, I use queries below to find out how much buffer pool memory...

sure.. you can recover them by issuing command

restore database [databasename1]

October 2, 2018 at 12:45 pm

#2007771

audit is one thing, I get alert right away when permission are changed.   Just setup WMI alerts and don't forget to setup operator and mail. 

Thanks Guys

no one Really?

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'...