One or more of your databases will not be in an online state so you cannot map a user to it.  to prevent any errors SQL gives you the warning...

So is that 2 x 24 cores so 48 cores total?  Or 2 x 12 core to make 24cores total.

I read it as you have 48 cores as such...

Can you...

Google Translated, appologies for any miss translations, Googles fault

Personal

I'm with SQL 2019 Enterprise, running on a VM in Sphere 6.5 on a 2-processor server with 24 core, it runs itself...

Query or server set to MAXDOP 2 by any chance?  Or resource governor implemented to restrict CPU for a particular workgroup classification?

What is the goal here?  To backup the database to the O drive?  If so you cannot.  SQL can only backup to drives which are local to the SQL server...

If someone has gone and setup CPU affinity on the instance then yes.

Do you have multiple SQL instances on the Virtual Machine?  Maybe someone has setup affinity so that it...

sys.dm_exec_connections will tell you if anything is connected using an encrypted session

but if that returns false for all the connections you would need to ask someone with access to configuration...

So you have two setups,

one the traditional failover cluster, shared storage

the other an AOAG, separate storage

The AOAG "should" be quicker to failover as all that is happening is moving the...

All of the old "product" based certifications are being retired on the 31st Jan 2021, so if your working towards getting any of the MCSA/MCSE/MCSD based certifications get it done...

Can pull the excel list from here then load it in the the DB https://sqlcollaborative.github.io/builds which is probably the easiest method, otherwise subscribe and scrape https://sqlserverbuilds.blogspot.com/

If the value is in a variable you need to strip you just pass it direct to the function

DECLARE @ConStr VARCHAR(10) = '1.2Kv'
SELECT Clean1 = CAST(ISNULL(pr.newString,0) AS...

Would say you have a network issue somewhere.  Have you spoke to the networking admins and asked them to trace route and packet capture so you can see whats going...

Supported from SQL2016 onwards in sync mode only so you should only be using AG's to provide the HA portion.  You want DR you need to build in logshipping solution...

Strongly suggest you get a copy of DBATools downloaded from the powershell gallery and start learning how that can help to elevate a lot of the pain when migrating.  It...

Don't detach attach the system DB's

You need to migrate the objects individually, logins, linked servers, jobs etc anything thats server side and not DB side.

Putting a 2017 master on a...