Yes,  you can restore from the same backup to both the primary and secondary.

Remove the database from AG, disable transaction log backups for that database on primary, restore to primary...

It appears that some line items are too large for a single line in the report - and that line grows causing that page to display less line items.

You can...

What I see is that you have a single data file for tempdb - you should have more than that...how many will depend on a lot of factors, but you...

Alerts will not cause any performance issues.  Checking policies won't cause any performance issues.

There are a whole set of agent alerts that you can define for AG.  I wrote the following script to add the alerts on my AOAG systems:

...

Because you've effectively turned the...

I would not recommend that approach - combining discrete data elements into a single column will make it much harder to work with that data.

What is the purpose of combining...

You need to validate the constraint connections between your tasks.  For example - if you have a task to perform backups, and 2 separate tasks for notification, then one of...

If you have the following - what do you want to do?

Employed = 'Staff', Non-Employed = 'Not Yet', Retired = 'Soon'

Or...

Employed = 'Soon', Non-Employed = 'Getting Hired', Retired = 'Long...

That is by design - the password is stored 'securely' in the catalog, which means the connection manager dialog box will only allow you to overwrite the saved password.

Why would...

It is not unexpected - it depends on what is processing at the time you look at the utilization.  Temp tables do not retain data - once the connection is...

Try running sp_configure without the reconfigure on your test instance - and see if the values from DBCC CONFIG actually change.  My guess is that they won't change until a...

One thing you stated that is of greater concern to me:

CPU hits max 60% most of the time so no big concerns there

I would say this is actually a...

If you want to be able to list the latest file in a directory - you can use Powershell:

PS> dir | Select -Last 1

If there are other...

Hi Alex,

Its is a full backup. Don't know the reason why , when backup is in progress , it was showing the backup file size as 822 GB but...