March 1, 2011 at 1:52 am
Hi All,
Can any one tell me what is DB Refresh and the process of prechecks,actual refresh , post check while performing DBREFRESH.
Thanks All
March 1, 2011 at 10:55 am
Hi,
As far as I know, DB refresh indicates the restoring the Prod db backup onto a test server. Usually, the Test/Dev teams would require prod data to work on some defects etc. In such cases, DBA's would restore prod db backup. They would replace existng DB in Test environ or create a new db.
when you restore db's, most probably, you would face orphaned users, which can be fixed by running sp_change_users_login procedure.
Checks:
Script out all the logins/users etc in the test db.
inform dev team to take backup of their SP, Views etc.
Kill any user connections.. such connections wont allow you to refresh/restore the db.
Restore the db and then run the login/user script followed by sp_change_users_login for any orphaned users
Thats all I know... anybody can further enlighten on this.
March 1, 2011 at 2:16 pm
...also, you may want to somehow "hide" personal and confidential information you do not want to be available to testers and developers like SSN, CC#, salaries, phone numbers, addresses, etc.
Please note the term "hide" is used here in a broad sense, you may want to replace SSN and CC# for some already agreed with business test values, scramble digits on phone numbers, convert salaries according to a HHRR provided table, etc. The idea is to have good testing data without exposing personal/confidential data.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply