• A backup is a page level copy of the original, so there is no need to perform another re-index or re-stat after restoring.

    Also, if your reporting database is static after restoration, then you may consider setting it to read only mode, which can offer some query performance benefits.

    ALTER DATABASE [DB] SET READ_ONLY;

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho