Getting SQL Server 2005 production ready...

[bmgmzp]

I'm bringing up our first SQL Server 2005 production server. Does anybody have any advice as to what to watch out for, what not to do, what to do, etc...

I'm just nervous and want to make sure all my bases are covered... its 10 times harder to make changes once we release this server into production.

Thanks ;-)

 

[ptheriault]

Check the size of your databases after you move them. There is a bug that will cause the databases to grow very large the first time they hit an autogrow. Also, Make sure to reindex, update stats and run backups before you go live.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[SQLDenis]

rebuild all your indexes and update all your stats after moving the DB from 2000 to 2005
create a file per logical CPU for tempdb

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions