|
shiyam198
Yak Posting Veteran
82 Posts |
Posted - 01/29/2013 : 15:52:48
|
Hi,
I do regular upgrades to clients, which has sql scripts that make schema changes, data changes, etc. Whenever I do these upgrades, I take a full backup and then run the scripts, and go back when a script errors out. Now the clients have grown so much and the databases taken like 4 hours to backup and 4 to restore, is there a quick way a go back in case of an error? (Like quick system restore on Windows, etc). These are production system. so they should be reliable too.
Please let me know how you handle this scenario.
Regards, Shiyam
|
|