Hi All, I am new to SQL management, i need your expertise on how do you manage SQL standalone, Clustered, AlwaysOn etc in terms of Log Management Backup & Storage Cumulative patch updates Other Important tasks for maintaining SQL Appreciate if there is any useful guide on L1/L2/L3 level activities to be performed weekly, monthly and yearly. I have almost 200 SQL servers. Please advice

Hi, As Olaf said, the question involves a lot of technologies that could not be talked with only few words. Actually the truth answer to these are at MS Docs, that you could easily google out. But I know this is not expected. I would suggest to get particular question so forum users could find a way to contribute and discuss with you. Regards, Lukas

SQL Management - CU Patch, Log, Backup

karthik palani 1,036

Hi All,

I am new to SQL management, i need your expertise on how do you manage SQL standalone, Clustered, AlwaysOn etc in terms of

Log Management
Backup & Storage
Cumulative patch updates
Other Important tasks for maintaining SQL

Appreciate if there is any useful guide on L1/L2/L3 level activities to be performed weekly, monthly and yearly. I have almost 200 SQL servers. Please advice

Olaf Helper 45,366 Reputation points

2021-02-11T12:47:29.293+00:00

It's really not possible to teach you the whole SQL Server administrative world with some forum posts.
Get some SQL Server trainings, read tutorials and make some hands-on session to get practice.

If you have more specific question (yours here are very wide), please feel free to come back and ask.
karthik palani 1,036 Reputation points

2021-02-11T13:21:37.687+00:00

I do take care of SQL not completely in-depth. Moreover i just need an high level information

I am not expecting answers in detail. Hope i will get someone to suggest. Thanks for your suggestion

1 answer

Lukas Yu -MSFT 5,821 Reputation points

2021-02-12T06:54:29.757+00:00

Hi,

As Olaf said, the question involves a lot of technologies that could not be talked with only few words.
Actually the truth answer to these are at MS Docs, that you could easily google out. But I know this is not expected.
I would suggest to get particular question so forum users could find a way to contribute and discuss with you.

Regards,
Lukas
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SQL Management - CU Patch, Log, Backup

1 answer

Your answer