SQL Management - CU Patch, Log, Backup

karthik palani 1,011 Reputation points

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.
11,592 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,634 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,323 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,806 Reputation points


    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.


    0 comments No comments