Scheduled a Microsoft SQL restore to a different server but file name date does not update

hello @gary mcneely 

it's typical for the .bak file itself not to have its date updated after each restore operation. Instead, the restore job simply uses the existing .bak file to perform the restore operation, so the file date remains the same
Here's a quick note what is happing in MS SQL restoer  the .bak file date does not change because the file is not being recreated or modified; it is used as is for the restore process and the restore job reads from the .bak file and applies the data to the target server. The file itself remains static in terms of its timestamp

You can find all the information here  https://documentation.commvault.com/11.20/sql_restore_options_general.html 

About Advanced Restore Options: 'Latest Backup Data'

The 'Latest Backup Data' feature enables the restoration of the most recent backup data on one or more non-system databases within a SQL Server. This option allows you to create a redundant copy of your primary SQL Server database, known as a hot standby server, within the same domain, a different domain, or across a Wide Area Network (WAN). This feature provides a reliable and efficient way to maintain data availability and minimize downtime in case of unexpected database failures or disruptions.

You can find all the information here  https://documentation.commvault.com/11.16/advanced_restore_options_options_03.html


 

Additionally, you can use this feature “Pre/Post Process” to run script to modify the file's attributes after the restore job is complete.
https://documentation.commvault.com/2023e/expert/pre_post_process.html 
I hope this helps! 😁 

Best Regards,
Mohamed Ramadan

Data Protection Specialist 

@Mohamed Ramadan 

Please let me know how I can overwrite the already present .bak file when performing a SQL restore ? 

Please also let me know what settings I need to adjust to just restore FULL SQL restores ?

My scheduled sql restore job settings are below.

hello @gary mcneely 
I hope you are doing well ,

In this case, you can follow these steps:


1- Use the “Advanced Restore” option

 2- select the "Unconditionally overwrite existing databases or files" checkbox to overwrite any existing databases or files.

3- Click on “Advanced” where you’ll find several options:

• Select "Restore to disk" and provide the desired path.
• Choose "Latest backup" for the most recent restore point.
• Select "Full backup only" to restore only full SQL backups.

Best Regards,
Mohamed Ramadan

Data Protection Specialist