REFRESH PRODUCTION DB to DEVELOPMESQNT

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » REFRESH PRODUCTION DB to DEVELOPMESQNT

REFRESH PRODUCTION DB to DEVELOPMESQNT

Rate Topic

Display Mode

Topic Options

Author

Message

goofy2sql

Posted Monday, December 12, 2011 8:46 PM

Forum 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.
SS

Post #1220568

Pradyothana Shastry

Posted Tuesday, December 13, 2011 3:13 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, March 25, 2013 5:30 AM
Points: 1,640, Visits: 423

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

- Pradyothana

http://www.msqlserver.com

Post #1220719

Steve Jones - SSC Editor

Posted Tuesday, December 13, 2011 8:31 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:26 PM
Points: 31,425, Visits: 13,738

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)

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 »

Permissions