How to set up backup MS SQL base on windows client?

Hello @elizabeta 

For installing the agent there are a few options:

Simplest way if using Command Center 

https://documentation.commvault.com/2022e/essential/142925_complete_databases_guided_setup_for_sql_server.html

If you do not leverage the command center than you can do this also in Commcell console

https://documentation.commvault.com/2022e/expert/18114_getting_started_with_sql_server_agent.html

Hello,

@Scott Reynolds thank you for your answer.

I have installed SQL agent.

Now I need to set up a backup on the Windows client for SQL databases.

I need to adjust the schedule for full backup and transaction log backup.
What all needs to be enabled on the client to set up Transaction log backup?

BR,
Elizabeta

Hello Elizabeta,

It sounds that the next steps are for you to configure a schedule. 

If you have created this in the Command Center you will have the RPO associated to the plan

https://documentation.commvault.com/2022e/essential/96314_configurations_for_rpo.html

If you have created this in the Java GUI you will need to create a Scheduled Policy and associate it to the subclient of your new agent

https://documentation.commvault.com/2022e/expert/6694_creating_automatic_schedule_for_database_log_backups.html