• If you only need data on the reporting server nightly have you considered log shipping? Just hold off on the restores during the day and have the database in standby\read only mode

    ---------------------------------------------------------------------