you should do both rebuild index and update stats.

also follow the same order.

DBCC FREEPROCCACHE...just to flush out old query plans

1) Rebuild Index

2) Update Statistics with Full Scan

3) DBCC UPDATEUSAGE

4) Fix Orphaned Users

Have you installed SP3 on both the nodes?

check the backup file again.If it has .BKP extension then it can only be restored with Litespeed.

if its litespeed backup it will have a extension .BKP

I dont think its Litespeed backup.

did you check the user mapping?

after you rebuild index and update statistics(with full scan) go with DBCC FREEPROCCACHE,this will clear the cache plan.

SQL SERVER 2005 - Administrator`s Companion

very good book to begin with.

Run upgrade advisor from your local machine.

Any SQLSaturday events in Chicago Area??

I will go for DBArtisan - its from Embarcadero

check this link for more info

http://www.sql-server-performance.com/software/review/dbartisan_p1.aspx

Thanks Lowell....This will be useful for me.

DB Artisan - Embarcadero

SQL Diagnostic Manager - Idera

Windows Explorer --> tools --> Map Network Drive --> //server IP/drive letter$/