I need to set up a nightly process that will refresh a database from another database. We have some complicated reports that users are trying to run against our production database that is causing performance issues for the application users. The reports do not need to have real time data. Data as of last night is perfect. We have some scripts that will drop and recreate a database, and then do a redirected restore of the database from a backup. However, rather than doing this manually, I would like to automate this. The production database is already backed up nightly, and I can get the image to the server where I would like to restore it. I am using Task Center, but it is running from a different server then the server I want to refresh. I was trying to use the task center, but I can't seem to get the restore working.
Now, I will be the first to admit that there is probably a better way of doing this. So, any help would be greatly appreciated.
Now, I will be the first to admit that there is probably a better way of doing this. So, any help would be greatly appreciated.
Comment