MS SQL Server - move a database to another location

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

move a database to another location

hershel

2006-02-28, 8:23 pm

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?

Tim Purcell

2006-02-28, 8:23 pm

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.

Sponsored Links