What is not persisted in a database backup / restore? (SQL Server 2005) If I take a backup of a database on a SQL 2005 Server, and then restore that backup to a different (new) database on the same database server instance, what things will not be persisted (things like cached execution plans, statistics etc...)
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.