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.