Question

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

  • 18 November 2022
  • 3 replies
  • 69 views

Userlevel 3
Badge +11

Hello,

I can't find the documentation, please, what are the steps required to install a backup of the sql database on the windows client?

Thank you!

Best regards,
Elizabeta Krešo

 


3 replies

Userlevel 6
Badge +14

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

Userlevel 3
Badge +11

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

Userlevel 5
Badge +12

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

 

Reply