Mimic SQL Server environment

I have SQL Server 2000 installed on Windows 2003 server. SQL Server
environment was set up about a year ago. I would like to known all of the
items I need to look at on SQL Server to mimic this environment. I have
started with SQL Server configuration (sp_Configure).
What items am I missing to mimic SQL Server?
Thanks,
Depends on what you mean by mimic...
You might wish to ensure the IO subsystems are the same.
You might wish to ensure each database is set up similary in physical
structure as well as attributes ( sp_dboption)
You might with to ensure the logins match. ( look in books on line for log
shipping and there is a document about how to make the warm standby the
production server. It includes a section on making the logins and users
match.)
Think about whether replication needs to be matched.
Think about sql agent jobs, etc ( included in msdb).
Hope this helps...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark T." <Mark T.@.discussions.microsoft.com> wrote in message
news:D76C7697-5336-494A-ADA5-ABC75B7AB421@.microsoft.com...
> I have SQL Server 2000 installed on Windows 2003 server. SQL Server
> environment was set up about a year ago. I would like to known all of the
> items I need to look at on SQL Server to mimic this environment. I have
> started with SQL Server configuration (sp_Configure).
> What items am I missing to mimic SQL Server?
> Thanks,