SQL Server database backup

Question

Hi Expert,
We are not taking any Full backup for databases except TLog backup. Commvault backup is running every day on most of the production Server and I asked Commvault Admin to verify how it is running. He said Commvault is taking only Disk level backup such as MDF and LDF. In terms of disaster they can only restore MDF and LDF and Tlog backup. If Commvault can't bring the database nonrecovery then all Tlog backup will be pointless in my understanding.

Should I rely on this kind of backup? Please clarify me

Thank You,

Answer 1

If Commvault can't bring the database nonrecovery then all Tlog backup will be pointless in my understanding.

Yes you are correct, unless Comm Vault takes proper full backup the log backups you are taking is useless. A disk level backup which means basically taking copy of mdf and ldf files will not help in point in time recovery.

Should I rely on this kind of backup? Please clarify me

Basically that depends on RPO and RTO but in most cases this is not good backup policy. If Comm Vault would have been taking "proper" SQL Server full and log backups it would have been reliable but disk level backups are only always considered as secondary backups. I would suggest you to talk with Comm vault team and see if they can start taking proper backups, if not, you start taking SQL Server backups using TSQL or Maintenance plans.

Answer 2

Hi @Zahid. Ahamed ,

...Should I rely on this kind of backup? Please clarify me

Commvault is one kind of backup tools,it may has its valuable and its own features, but in my opinion, all backup essence (Copy the contents of data files and log files) and restoration essence are same.If you just want to backup and restore, you do not need additional softwares, SQL Server can achieve it easily. What you need is to make one suitable backup policy,and then create a job to execute it automatically.However,whether to use commvault or not is up to you.

More information: sql-server-database-backup-tools，how-to-create-and-manage-sql-backup-policies,quickstart-backup-restore-database

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Hi @Zahid. Ahamed ,

Is the reply helpful?

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.