Any advise?

Guys, finally I got the culprit login from audit login trace. It was really hectic but got the issue though. Feeling better now.

Hello,

While restoring databases from one node to another, getting the below error. The other node is added as a linked server and the db size is 50 GB.

I am constantly checking the sys.processes to find if there is any user connection is being made on the database which is part of Alwayson,. but do not see any...

But when I right click on the database and check properties I see the below error which is kind of weird.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Yes,,thanks Jon.

Thanks much for the advise. It worked. I think that "N" solved my issue by converting varchar to char!

This is the whole script. The issue is at the restore side while executing the command in Primary node to run the restore on the secondary node (that node...

any advise please?

The below section does not seem like a valid condition. As the node names may not be added to the servers table. Nevertheless awesome script!!

SELECT...

If I need to add multiple databases to the AG group how to tweak the code?

Any way to suppress the alert? Can we use any trace flag to suppress it?

I'm running the below query but not seeing any recompile column.

Am I missing something?

SELECT TOP 1 d.object_id, d.database_id, OBJECT_NAME(object_id, database_id) 'proc name', 
 ...

Is there any possibility to read from extended events to find when recompile occurred sql server @procedure level?