Posted by Simon Hayes on 07/08/05 19:30

"joshsackett" <joshsackett@gmail.com> wrote in message
news:1120837924.559494.225710@z14g2000cwz.googlegroups.com...
> Hi all,
> I have 5 databases, each about 20GB in size. I need to copy the data to
> a new server for reporting purposes. Initially I wanted to setup
> transactional replication; however, the database schemas often change
> (adding or modifying tables) and in order to accomodate those changes
> through replication I would need to send a new snapshot each time a
> change occurs. This is very time consuming.
>
> So I decided instead to use log shipping, until I realized the
> reporting databases would be unavailable during the period when the
> transaction log was being applied. That also will not work.
>
> So what does everyone else use? My only requirements are that the
> reporting databases be available during business hours and there be
> very little administration when it comes to changing the database
> schema.
>
> Thanks,
> Josh
>

What about simply using backup and restore? If they only have to be
available during business hours, then you have all night to do that, unless
of course you have multiple offices in multiple time zones, which would
reduce your maintenance window.

Simon

[Back to original message]