Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Posted Monday, December 12, 2011 8:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 5:27 PM
Points: 6, Visits: 137
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.
Post #1220568
Posted Tuesday, December 13, 2011 3:13 AM



Group: General Forum Members
Last Login: Saturday, December 5, 2015 3:41 AM
Points: 1,702, Visits: 481

- Pradyothana
Post #1220719
Posted Tuesday, December 13, 2011 8:31 AM



Group: Administrators
Last Login: Yesterday @ 9:43 PM
Points: 32,983, Visits: 17,263
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 (

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 (

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1220942
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse