On Tue, May 24, 2005 at 21:39:15 -0500,
John A Meinel <john(at)arbash-meinel(dot)com> wrote:
>
> By the way, I think doing:
>
> CREATE DATABASE tempdb WITH TEMPLATE = originaldb;
>
> Is a much faster way of doing dump and load. I *think* it would recreate
> indexes, etc. If it just does a copy it may not show the dump/restore
> improvement.
You need to be careful when doing this. See section 18.3 of the 8.0 docs
for caveats.