What i am doing is when system is running fine after thorough testing, i am taking backup of alf_data & db backup.But i am facing typical issue sometimes as after restoration of the same alf_data & backup on another machine with exactly same configurations, its not successful & some sandboxes are corrupted or something other going weird without any notice.What can be the reason?Should i take war as a backup also but that way restoration is lengthy & not user friendly.
Any idea how to reduce chances of failure & make backup & restoration 100% successful?
You need to give more details of your "weird" errors.
Here's a couple of thoughts. Is your database backup a consistent snapshot? On some DBs that can be tricky if the DB is under load. Are your database settings such as collation order the same?