Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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)

Copy/Refresh a database in the night

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.

Total article views: 2523 | Views in the last 30 days: 4
Related Articles

Backup Schedules & Sizes Report

Backup Schedules & Sizes Report


Backup Monitoring and Reporting

Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily ...


SQLServerCentral Article on Backup Monitoring and Reporting

The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I ...


sql server login on overnight report server

DTS copies backup and restores to report server


Reporting on Activity across Multiple Servers using SQL Backup and SQL Multi Script

Rodney Landrum presents a creative solution for dynamic reporting across all of his SQL Servers, bas...