Skip to main content
commvault.com commvault.com
Question

SQL DB Restore

  • November 7, 2024
  • 7 replies
  • 71 views
S
Commvault Certified Expert
Forum|alt.badge.img+12
  • SSchmidtCommvault Certified Expert
  • Commvault Certified Expert
  • 90 replies

Hi All,

 

we are looking for an solution to backup an 7TB big SQL Server and restore the hole instance in 2h this is the customer wish. 

 

I think the normal streaming backup is not working for this part. Maybe when the mediaagent has an all flash maglib behind and the network is 50GB and the sql server vm is also running on an nvme enviroment. 

 

So we are thinking what can we do to backup the DBs and get an quick restore. 

 

One Point ist the intelli snap for nutanix. Our idear is to run ever 4h an intellisnap for nutanix backup and copy it out to cv. Also we would like to install an sql cv agent inside of the vm run daily full + daily diff + every 15 minuts trans logs but no my question regarding the way back. 

 

Lets say we have now 10:00 may last vm snap was at 06:00 and my logs are running every 15 min no i do an revert of the snap to 06:00 is it possible to restore over the commvault agent only the logs to 10:00 ? We want to prevent that the agent is restoreing the hole stuff from full + diff + trans we want to minimze the restore time with this szenario. Is it working ? can i restore sql logs only ?

 

do you have other idears 

7 replies

S
Vaulter
Forum|alt.badge.img+7
  • Sujay kumarVaulter
  • Vaulter
  • 70 replies
  • November 8, 2024

Dear @SSchmidt  
please review advanced restore option to apply logs backup only/ skip Full backup options
reference
https://documentation.commvault.com/11.20/advanced_restore_options_options_03.html
 

Apply Log backups only

Only available when the Latest Backup Data option is selected. Select this option if you wish to include only the transaction log backups completed since the last restore operation. The restore operation will then skip any full backup jobs completed since the last restore operation.

Note

  • Before selecting this option verify that the databases are in standby state or restoring state.

  • If you do NOT select the Apply Log Backups Only option and the database already exists, all backup jobs completed since the last restore operation will automatically be restored.

  • If you do NOT select the Apply Log Backups Only option and the database does not exist, the software will automatically perform a full restore of the database.

 

S
Commvault Certified Expert
Forum|alt.badge.img+12
  • SSchmidtCommvault Certified Expert
  • Author
  • Commvault Certified Expert
  • 90 replies
  • November 8, 2024

Hey @Sujay kumar 

 

thanks for this hint. I have an question:

 

Apply Log backups only

Only available when the Latest Backup Data option is selected. Select this option if you wish to include only the transaction log backups completed since the last restore operation. The restore operation will then skip any full backup jobs completed since the last restore operation.

 

In my scenario the restore wasnt started from commvault end. The VM snap was reverted and i only want to restore the logs. So my question is does it work to apply the logs only even when no sql restore job was running before ? 

S
Vaulter
Forum|alt.badge.img+14

@SSchmidt For the apply log backups only to work the full and diff (if there are diffs) must first be recovered in a standby or norecovery state then and only then can logs backups be applied.

This is a function/requirement of MSSQL recovery. The restore could be started from another application but it would a revert would not work as that is just bringing back the DB as normal/online database it needs to be a restore.

 

S
Commvault Certified Expert
Forum|alt.badge.img+12
  • SSchmidtCommvault Certified Expert
  • Author
  • Commvault Certified Expert
  • 90 replies
  • November 13, 2024

Hey Scott,

 

so there is no way to only deploy the logs only from cv end after the vsa restore ? 

S
Vaulter
Forum|alt.badge.img+14

That is correct.

S
Commvault Certified Expert
Forum|alt.badge.img+12
  • SSchmidtCommvault Certified Expert
  • Author
  • Commvault Certified Expert
  • 90 replies
  • November 13, 2024

Damm :) could intellisnap for nutanix be an option for this szenario or is streaming backup not the solution and we have to go for netapp snapmanager productuct. bye the way do you know some other vendors wich can do array snaps with application integration ?

S
Vaulter
Forum|alt.badge.img+14

Array snaps are not an issue if using the SQL agent, you can restore full + logs

Unless I misread, you noted that you were going to restore the VM separately then go back and try to only apply logs that is unique scenario.

Having a large DB and strict RPO requirements intellisnap is the best option SQL agent can do clones/PIT, etc
https://documentation.commvault.com/2024/expert/getting_started_with_microsoft_sql_server_agent.html

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings