MS SQL Server - moving database from stand alone to cluster

Author

moving database from stand alone to cluster

jason

2005-08-31, 8:23 pm

hi
i am looking for some advice on how to move a database from a stand alone
sql server to a clustered sql server.

i tried the copy db wizard, it failed with a meaningless error

i tried to do a backup and restore and that works only if i restore it to
the t: drive,
i can't specify a different path (which is what i want to do). if i do
specfiy a different path for the data and log file, e.g. t:\data and t:\logs
it gives me and error stating i should use the "with move"

thanks

Brian Lawton

2005-08-31, 8:23 pm

Another option is to detach your database, copy the files across the network
and then reattach it on the new system. That said, doing a backup/restore
should work fine. You can get the full restore syntax from books online,
however, here the example for what you need to do:

<snip>
D. Restore a database and move files
This example restores a full database and transaction log and moves the
restored database into the C:\Program Files\Microsoft SQL Server\MSSQL\Data
directory.

RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH NORECOVERY,
MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\Ne
wNwind.mdf',
MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\Ne
wNwind.ldf'
RESTORE LOG MyNwind
FROM MyNwindLog1
WITH RECOVERY
</snip>

--
--Brian
(Please reply to the newsgroups only.)

"jason" <jason@discussions.microsoft.com> wrote in message
news:544B9192-C834-4DAA-AECD- 132850587BED@microso
ft.com...
> hi
> i am looking for some advice on how to move a database from a stand alone
> sql server to a clustered sql server.
>
> i tried the copy db wizard, it failed with a meaningless error
>
> i tried to do a backup and restore and that works only if i restore it to
> the t: drive,
> i can't specify a different path (which is what i want to do). if i do
> specfiy a different path for the data and log file, e.g. t:\data and
> t:\logs
> it gives me and error stating i should use the "with move"
>
>
> thanks

Sponsored Links