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: Yesterday @ 3:01 AM
Points: 430, Visits: 1,067
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: Yesterday @ 7:06 PM
Points: 7,125, Visits: 12,720
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
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: Yesterday @ 3:01 AM
Points: 430, Visits: 1,067
Thanks..
Post #1452990
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse