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. MadduriSQL 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.
Moderator
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
http://www.SQL-Server-Performance.Com
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.
]]>