Re: Fastest way to duplicate a quite large database

On 4/12/2016 7:25 AM, Edson Richter wrote:
>
> I have a database "Customer" with about 60Gb of data.
> I know I can backup and restore, but this seems too slow.
>
> Is there any other option to duplicate this database as "CustomerTest"
> as fast as possible (even fastar than backup/restore) - better if in
> one operation (something like "copy database A to B")?
> I would like to run this everyday, overnight, with minimal impact to
> prepare a test environment based on production data.


copy to the same machine, or copy to a different test server? different
answers.



--
john r pierce, recycling bits in santa cruz