Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Jason S Wong,
I used this code to refresh a database from production to a report server every night. You can change the parameters to meet your purpose.
As we know, this is equivalent to doing log-shipping except log-shipping does not allow you to utilize destination server as a report server as it is constantly being restored.
Here we are doing it once a night. The report server data is fresh one day behind. If you copy the backup files from another server, add the shell copy commands to get your files.
In our environment, we are doing weekend full-backup and weeknight diff-backup, you might want to choose for your environment.
To find backup set history, see my other publications.
Backup Schedules & Sizes Report
Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily ...
The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I ...
DTS copies backup and restores to report server
Rodney Landrum presents a creative solution for dynamic reporting across all of his SQL Servers, bas...