moving sql databases to different server different location

How do I move databases currently on a cluster to a standalone machine with
different drives and location?You can use backup/restore or detach/attach. In the case of backup/restore,
you'll need to use the WITH MOVE option to specify the desired location of
the database files on the target server.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"nobody" <nobody@.nobody.com> wrote in message
news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
> How do I move databases currently on a cluster to a standalone machine
> with different drives and location?
>|||Hi
"nobody" wrote:
> How do I move databases currently on a cluster to a standalone machine with
> different drives and location?
>
As well as Dan's suggestions you could use sp_detach/sp_attach although this
would mean that your database on the cluster would be down while you copied
the files. See http://support.microsoft.com/kb/314546 also note the part
about orphaned users.
John|||how do you use the move option? I am using the gui and it does not give you
an option
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:8A59927E-2DD6-432F-8348-E32E2FC0A130@.microsoft.com...
> You can use backup/restore or detach/attach. In the case of
> backup/restore, you'll need to use the WITH MOVE option to specify the
> desired location of the database files on the target server.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23HdDWRTpHHA.3968@.TK2MSFTNGP06.phx.gbl...
>> How do I move databases currently on a cluster to a standalone machine
>> with different drives and location?
>|||Hi
"nobody" wrote:
> how do you use the move option? I am using the gui and it does not give you
> an option
The move options when using Enterprise Manager are on the option tab of the
restore dialog. For a T-SQL example look at example E of the Restore topic in
books online or at
http://msdn2.microsoft.com/en-us/library/aa238405(SQL.80).aspx, if the
database already exist on the desitination server, then you may need to add
the REPLACE option. If you are going to do this more than once then having a
script to do it will be easier.
John