move a database to another location

Hi All

How do I move a database from one server to another?

Is it a problem that the original server is SQL 2000 and the new is 2005?

hershel  wrote:
> Hi All
>
> How do I move a database from one server to another?
>
> Is it a problem that the original server is SQL 2000 and the new is 2005?
>
>
Hi

there are a couple of methods.  You can use the copy database wizard in
Management Studio which uses either the detatch/attach method or object
copy, or you can manually detatch-copy-attach, or just good old SQL
backup and restore into 2005.  Note that you'll need to change the
compatability mode.