Monday, May 31, 2010

Data base refresh in sqlserver 2005

Data base refresh is a concept that just dump your live data base to development environment.
It follows several steps:
1. Take full data base backup from your live environment
2.Copy that live data abse to development environment
4.Backup your existing logins information to some table in sys data base
5.Kill all your connnections in development environment
6.Restore your live data base to development environement by using restore data base or by wizard
7.Remove all existing live users from restored data base
8.Map development users to restored data base.

No comments:

Post a Comment