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…)
Sql-server – not persisted in a database backup / restore? (SQL Server 2005)
backupsql serversql-server-2005
Related Question
- Sql-server – How to list the database files contained in a SQL Server 2005 backup file using T-SQL
- SQL Server 2005 – How to Move (Restore) a Database That Does Not Exist
- Sql-server – SQL Server – backup / restore schema only
- Sql-server – Restoring differential backup from SQL Server 2005 to SQL Server 2012
- Sql-server – Backup Database (SQL 2000 Compatibility) on SQL Server 2005 with CHECKSUM, but Page Verification TORN_PAGES Detection
- SQL Server 2005 – Managing Backups with Maintenance Plans
- SQL Server – Restoring 2008 R2 Backup on 2005
- How to restore operational Oracle 11g Database from full backup
Best Answer
Plans will be recreated at first run.
Otherwise, everything database level will be there except where it interacts at the instance level, such as:
For a standard, everyday database, you've no worries.