I am not a DBA. I will be doing this for the first time. So I am not sure what all I am supposed to do?
I will be restoring sql server 2000 database to sql server 2008. Are there anywhere step by step instructions to do this?
I know I am supposed to change compatibility mode, rebuild indexes on all the tables.
It will really help me if there are step by step instructions.