Also, Below is a great T-SQL script to find startup time for SQL server, SQL Server agent and windows server.

-- ============================================================= --

-- Get OS, SQL Server, SQL Agent Restart times

select

@@SERVERNAME...

Thanks Grant. I am actually looking for getting notified for "any" new database get created in our subscription. For now as a workaround, we have restricted permission for only authorized...

Did you supply user name and password for authentication while creating DBMail account?

Please see below:
https://www.mssqltips.com/sqlservertip/2578/setup-sql-server-database-mail-to-use-a-gmail-hotmail-yahoo-or-aol-account/

I would not give my whole database to third party vendors.. Test in Dev/QA/Test environment before implementing any changes in Prod. If issue is not replicated to other environments and...

I opened a case with MS support. We enabled all required ciphers with the use of IIS Crypto tool on client server. Issue resolved.

No They are running the same operating system (Windows 2012 R2)

I have SSMS 2017 client on another Windows 2012 R2 server and from there I can connect to these servers fine.  The issue is only with this one client server...

Thanks, will keep digging..

It's better to put that in a standard folder. Make folder structure same across all your instances for better administration.

Very nice question. thanks. Learnt something new.

Is your account (account through which you are running this query) has access?

Check this out.

http://harshbiplus.blogspot.in/2015/01/failed-to-initialize-sqlcmd-library.html..

;WITH QUERY1 ( Total_Physical_Memory_In_MB,NumberofCPU )

AS (SELECT [total_physical_memory_kb] / 1024 AS [Total_Physical_Memory_In_MB],

CPU_Count AS NumberofCPU

FROM [master].[sys].[dm_os_sys_memory]

CROSS JOIN sys.dm_os_sys_info

...

Use SQL Sentry or Spotlight. Both are good tools for Monitoring. Go through documentation/user guide of those to see if that satisfy your requirements.

Thanks,

It will be Transactional replication with Pull from Subscription server.

So as per your reply,

- We need to backup distribution database

- We need to backup publisher database

- We neeed...

Sorry GilaMonster