How to copy production master db into test environment

SQL Server 2000 (sp3a) running on Windows 2000 (sp3)
My goal is to re-create our production environment in a test environment, on
a test sql server.
What is the proper method for copying the contents of our production
'master' database to a test server?
I've tried multiple DTS exports into the test server's 'master' database
without success.
Appreciate any help and suggestions.
ZawI prefer using BACKUP and RESTORE for this. You then have to handle your
users/logins mappings. Read about sp_change_users_login in Books Online for
more info on that.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"zaw" <threewise@.comcast.net> wrote in message
news:uYurJ5IqDHA.1960@.TK2MSFTNGP12.phx.gbl...
> SQL Server 2000 (sp3a) running on Windows 2000 (sp3)
> My goal is to re-create our production environment in a test environment,
on
> a test sql server.
> What is the proper method for copying the contents of our production
> 'master' database to a test server?
> I've tried multiple DTS exports into the test server's 'master' database
> without success.
> Appreciate any help and suggestions.
> Zaw
>|||i don't know what you want out of master, but if it's just logins use
sp_help_revlogin.
if it's jobs, script jobs on prod and use script to recreate on test after
editing appropriately.
if it's dts packages, save them to test server and then edit appropriately.
if it's databases, backup on prod and restore to test.
if it's publications and subscriptions, good luck ;)
zaw wrote:
> SQL Server 2000 (sp3a) running on Windows 2000 (sp3)
> My goal is to re-create our production environment in a test environment, on
> a test sql server.
> What is the proper method for copying the contents of our production
> 'master' database to a test server?
> I've tried multiple DTS exports into the test server's 'master' database
> without success.
> Appreciate any help and suggestions.
> Zaw