Publishing of data from batch server to WEB SQL server

  • Morning,

    We are running SQL 2008 R2 and I have a question about publishing of data.

    We have a batch server which run daily transforms and after the transforms have completed we need to publish this data to the WEB SQL servers. Currently we use snapping and cloning of the LUN's the SQL databases are on to get it from the one server to the other. This database is about 400GB in size and this cloning process takes about 1.5h to complete.

    We need to find another way of getting this data to the web sql servers. How do you people out there do this?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply