Click here to Skip to main content
15,665,942 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
Hi All,
I just finished create 3 node SQL server high availability setup now I need to know the best practices for the maintenance planes

1- Backups
2- DBCC check
3- Managing log files
4- Adding alerts
5- Rebuild Index

All the tasks about where is should be implemented on the primary node or on the secondary node?

What I have tried:

I checked YouTube and found a video about creating full backup on the secondary node.
Updated 26-Jul-20 21:45pm

1 solution

This is the Quick Answers forum, see Code Project Quick Answers FAQ[^]. Your question is one of research and MSDN and Google are the places to find information on these subjects. See SQL Server technical documentation - SQL Server | Microsoft Docs[^] to get started.
Share this answer
Al Mosaaed 27-Jul-20 3:52am    
I will check, thank you.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900