Sql Server 2005 Configuration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sql Server 2005 Configuration

Hi, We have installed sql server 2005 on a seperate server and are planning to move the production database presently on 2000 to 2005 server. I would like to make sure that the server has been configured correctly before we move the database. Please guide me how to go about it. Thanks in advance. Madduri
SQL Server 2005 Upgrade Handbook
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx SQL Server 2005 Books Online
How to: Upgrade to SQL Server 2005 (Setup
http://msdn2.microsoft.com/en-us/library/ms144267.aspx How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133 SQL Server Best Practices
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx MohammedU.
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Also search under the forums as this was asked here many times and much information available on top of what is referred above. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.