To recover the data on the failed drive the followings to be done:
- It is good practices schedule weekly backup schedule from Monday to Saturday as increment backup and Sunday as full backup.
- Normally backup schedule is running done at midnight time only.
- Either number of user will be less or no user will be access the database or network.
- As first step check whether drive has enough spaces. I not free the enough space and rerun the backup on failed drive.
- Check backup drives login where password changed.
- Check drive is mounted or on.
Check operating system user id and password changed in operating system or active. After troubleshooting, Rerun the task for Saturday.