Does it appear in sys.databases?

Thanks

What error message are you getting if you check the history of the job?

Thanks

This what I'm running (Database Name and Object Name have been changed):

SELECT *
FROM sys.dm_db_index_physical_stats(db_id('dba_database'), object_id('DDL_EVENTS'), NULL, NULL, 'detailed');
Are you running it on a SQL...

What script are you using to migrate the logins? If you're using sp_help_revlogin it should retain the sysadmin permissions.

Thanks

This all looks like homework and why have you posted it 3 times?

Thanks

So you have 1 full backup and 87 differential backups have been taken since the full backup? If that's the case you only need to restore the full backup with...

No it won't but I would have thought it would be very unlikely for there to be high memory use if the node is passive. The only problem you will...

A COPY_ONLY full backup does not affect the base for a differential backup and a COPY_ONLY transaction log backup does not affect the log backup sequence. I've probably not explained...

It is a CTE or Common Table Expression. The link below gives you more detail about them

https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-2017

Thanks

Have you tested doing a straight restore rather than attach? Also why are you using such an old version that is out of support (or very soon out of support...

You could try and restore it and see if it fails.
Why don't you want to run DBCC CHECKDB? it is the best way of checking for corruption.

Thanks