SQL Management - CU Patch, Log, Backup

karthik palani 1,016 Reputation points
2021-02-11T07:33:47.833+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,809 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,813 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 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

    0 comments