Thank you, Sir.

Your answers cleared up our questions.

Thank you so much for your prompt response.

I have inheritance SQL Server environment where the Server team, etc wanted to be System Admin on the SQL Server.

They might perform some upgrade.

And, I found the work-around.

https://support.microsoft.com/en-us/help/2163980/fix-the-sql-server-service-cannot-start-after-you-install-cumulative-u

I researched and found the SQL Error logs:

Error: 18401, Severity: 14, State: 1.

Login failed for user xxxxUser. Reason: Server is in script upgrade mode. Only administrator can connect at...

I verified that the user connect to right server and I was able to duplicate the same issues.

My Steps to duplicate:

1. Create SQL login = 'DBATest1' and assigned a password.

2....

Thank you, Jonanthan.  Very appreciated.

I'm reviewing Jonathan T-sql scripts and update shortly with questions.

Many thanks for Jonathan AC Robert and everyone helps.  I'm very appreciated.

I'm not hundred percent sure on the historian data that the business wanted to keep.   My best guest is one year.
Also, I did some research and some suggested...

I already setup SQL Audit.
There are many pre-existing Audit Action Type.
So far, I did not find one that can help me to monitor a user permission changed.

Is that any existing t-script that I can use to trace?

Thank you, All for your input.  The feedback answered my questions.

Questions:

I have a SQL Server 2008 R2 and have 100 SQL Agent jobs listed with different schedule and time stamps.

Now, I needed to add addtion 7 hours to the existing...

The best practice should create the database and allocate database size based on proper planning and estimate grow for minimum 3 years.

I won't let the application create the database.

Thank you and very appreciated.