SQL Server Modifying Production Data Good Practise
Posted by: SQL Server DBA,
on 21 Jan 2012 |
View original | Bookmarked: 0 time(s)
Q. I need to modify Production Data directly on a Production database. What are some steps I can follow to ensure rollback is possible? Also, some steps to ensure I can capture mistakes before the data becomes invalid
A. Here are some suggestions
1. Take a Log Backup before the change giving you a restore point
2. Sit with another DBA . They can verify what youre doing is correct. This is particuarly useful if late at night
3. Create a table backup , before beginning.
4. Create a transaction....