What is not persisted in a database backup / restore? (SQL Server 2005)
Plans will be recreated at first run.

Otherwise, everything database level will be there except where it interacts at the instance level, such as:


replication
backup jobs/schedules
maintenance plans/schedules
login mappings to users


For a standard, everyday database, you've no worries.