REFRESH PRODUCTION DB to DEVELOPMESQNT

Question

Post reply

REFRESH PRODUCTION DB to DEVELOPMESQNT

goofy2sql

SSC Veteran

Points: 282
More actions
December 12, 2011 at 8:46 pm

#150748

HI Friends;
I have a database in production which needs to be backedup and restored on Development box. THE PROD and DEV are two separate servers. The Development box has same databases that are on production. This needs to be replaced with latest production db's. Please help me the process I should follow;
1. TSQL SCRIPT to BACKUP (what options, like format, init etc)
2. RESTORE TSQL SCRIPT (what happens to existing files names on dev box.)
3. HOW are users need to be mapped again.
4. THESE PROD AND DEV. are in 2000 environment.
Thanks for the help.
SS

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Pradyothana Shastry SSCertifiable Points: 5211 More actions · Answer 1

http://www.msqlserver.com/2011/11/script-to-schedule-backup-all-databases.html

- Pradyothana http://www.msqlserver.com

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

I assume you are backing up your production database, correct? Just copy the latest full backup to the development server.

If you are replacing the databases on the Dev server with updated data from production, then you RESTORE them with the same name, using the WITH REPLACE syntax (http://msdn.microsoft.com/en-us/library/ms178615.aspx)

If the file paths are different on Dev from production, you need the WITH MOVE syntax.

Typically you have different logins/users on DEV than production. If they are the same, the logins need to be on the Dev box. If they aren't, sp_rev_helplogin from MS will help you move them.

To sync back up users with logins, sp_change_users_login (http://msdn.microsoft.com/en-us/library/ms175475.aspx)

naveen.neerukattu1228 Old Hand Points: 342 More actions · Answer 3

Hi i need some information which is related to database migration and Data base refresh.

when we need to perform Database Refresh and Database migration.

help me on this.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

naveen.neerukattu1228 (3/19/2016)
Hi i need some information which is related to database migration and Data base refresh.
when we need to perform Database Refresh and Database migration.
help me on this.

Please start a new thread for your question and give more detail. What you are asking here isn't a specific question, but general information on a topic, which is hard to give without understanding of what you are trying to do.