Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved 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: 2485 | Views in the last 30 days: 4
 
Related Articles
FORUM

Backup Schedules & Sizes Report

Backup Schedules & Sizes Report

ARTICLE

Backup Monitoring and Reporting

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

BLOG

SQLServerCentral Article on Backup Monitoring and Reporting

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

FORUM

sql server login on overnight report server

DTS copies backup and restores to report server

ARTICLE

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...

Tags
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones