February 16, 2014 at 6:28 am
Could any one explain the steps involved in database refreshment or any useful links relating to that.
I have dought in refreshment activity
1. if we restoring a production database on test server. The permissions to users in Production are different from test server.
February 16, 2014 at 9:27 am
The details are going to vary for your environment, but here's roughly how we used to do it:
1. Get a copy of the production backup
2. Restore it to a test machine. There, do several things
a. Clean the data, remove email addresses, phone numbers, sensitive information
b. Remove production logins and users, add development logins and users
c. Shrink the database if we could
3. Backup the cleaned and shrunk database
That was then used to send down to Development and QA and wherever. It's mainly just a matter of writing the scripts to do the work. There's no special tricks to it.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply