Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

deploying changes to a live database Expand / Collapse
Author
Message
Posted Wednesday, May 15, 2013 12:29 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:04 AM
Points: 410, Visits: 996
Hi,


What are some major risks for deploying changes to a live database, and how would we mitigate them?
a. Stored procedure changes?
b. Indexing changes?
c. Schema changes?


Thanks
Post #1452934
Posted Wednesday, May 15, 2013 1:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
Some initial thoughts on the matter:

- Verify that you have valid database backups in place before changing a live environment.
- Have a rollback plan setup ahead of time in case something goes wrong so you can recover to the point before the changes without any loss of data.
- Test your changes in a non-production environment prior to attempting anything with a live database, including testing your rollback plan.
- Have a verification plan in place so after your changes go out you know ahead of time how to verify that they were successful. Be prepared to make a "go or no-go" call during or after the verification steps have been run.
- Consider whether you need to take the database offline during the changes, what impacts that might have on user applications and how you might need to communicate the outage is end-users will be affected. If you cannot take the database offline consider how that will affect your rollback plan.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1452957
Posted Wednesday, May 15, 2013 3:26 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:04 AM
Points: 410, Visits: 996
Thanks..
Post #1452990
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse