On 26 Aug 2005 11:02:12 -0700, bdog_jdog wrote:

> Steve, assuming your testing in a non-production environment, here's
> how to do that:
>
> 1. Make a full backup of the database(s) in question on your SQL 2000
> instance, copy files to the box running Express 2005 (if necessary)
> 2. Go to your Express 2005 instance, create a new database
> 3. Restore the database using your backup created in Step 1, and in the
> Options tab, be sure to Force Restore Over Existing Database, and
> resolve any discrepancies/differences with filenames and locations.
>
> That should work fine, but I should say I haven't tried it, I recently
> downloaded the CTP of 2005 Standard, but I haven't had a chance to
> install it.
>
> B