October 4, 2009 at 9:57 pm
Hi,
Can any help in post installation steps for sql server 2005 enterprise edition?
Thank you
Koteswar Rao.Y
October 5, 2009 at 1:12 am
October 5, 2009 at 1:57 am
See also http://msdn.microsoft.com/en-us/library/ms143693(SQL.90).aspx for some insight.
October 5, 2009 at 5:20 pm
1. dbcc updateusage with count_rows
2. sp_updatestats
3. Rebuild all indexes (individually)
4. DBCC for DATA_PURITY
5. Change page verification to CheckSum (from Torn page)
6. Switch to dblevel 90
7. Run scripted logins and jobs in sql server 2005
8. create a new backup
9. Perform test by the application team(s)
Put the logins, jobs in after the databases have been successfully restored otherwise they will likely try and reference databases that dont exist
MJ
October 5, 2009 at 10:18 pm
1) Change the min and max memory settings accordigly.
2) Check the recovery model of system db`s and check backup jobs.
3) check if you need any sp_configure advanced options.
4) builtin administrators should be removed.
October 6, 2009 at 3:12 am
You may find SQL Server FineBuild useful. The Reference manual has about 50 pages of post-install configuration work that is worth doing.
The aims to get you going with a best-practice configuration, but each site may well have unique requirements that also need to be appiled.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
October 6, 2009 at 6:33 am
You may also want to change :
1. Number and size your Tempdb data files
2. Default location of User databases
3. Enabled network protocols
4. TCP/IP default port number
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply