Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

REFRESH PRODUCTION DB to DEVELOPMESQNT Expand / Collapse
Author
Message
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.
SS
Post #1220568
Posted Tuesday, December 13, 2011 3:13 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 1:58 AM
Points: 1,689, Visits: 455
http://www.msqlserver.com/2011/11/script-to-schedule-backup-all-databases.html


- Pradyothana


http://www.msqlserver.com
Post #1220719
Posted Tuesday, December 13, 2011 8:31 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:38 PM
Points: 31,368, Visits: 15,834
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 »

Add to briefcase

Permissions Expand / Collapse