MSSQL setting

Hi All,
we will have another server to be set up as DB server, we currently have another SQL server, we want the 2 server have same
settings, how can i do this or any tools can help to do this? thanks all
Hi,
I understood that there must be various third party tools available,
however, I would love to recommend you the following Knowledge Base
articles to do the job
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/kb/314546
This step-by-step article describes how to move SQL Server user databases
and most common SQL Server components between computers that are running
SQL Server.
Hope this helps.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!