1.Depending on the company Policy, it is better to have an approval from the management for any such change.
2. Always have a Rollback plan handy.
3. Backup and restore works good, but may NOT be the best solution on a production sever esp running 24 x 7
4. For data migration we have DTS or SSIS depending on what version of SQL Server you are using.
Thanks!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."