Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shiyam198
Yak Posting Veteran
94 Posts |
 Posted - 2013-01-29 : 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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Best Way to go back in case of an error