I am planning to put SQL 2000 database on SQL Server 2008 in SQL 2000 Compatibility mode, I believe it should work as I tested it.
My questions are .
1. In terms of database administration what would be the challenges to maintain the database? like index re-build via SQL 2008 plan? update stats? etc.. 2. Any issues in terms of applying security patches etc...
More around DBA maintenance side any risks we need to worry about?