restore database to different partition

Our client has an SBS 2000 server with SQL 2000 installed.
The server has 3 separate physical hard drives. I am
moving the data to a new server with 1 large physical hard
drive. My question is what is the easiest method to move
the data from the old server to the new server, keeping in
mind that the partions are changing. I don't want to
create the partions on the new server.
Thanks for the help,
JohnSee sp_attach_db and sp_detach_db in BOL. Or you can use
DTS or the backup/ restore method.
>--Original Message--
>Our client has an SBS 2000 server with SQL 2000
installed.
>The server has 3 separate physical hard drives. I am
>moving the data to a new server with 1 large physical
hard
>drive. My question is what is the easiest method to move
>the data from the old server to the new server, keeping
in
>mind that the partions are changing. I don't want to
>create the partions on the new server.
>Thanks for the help,
>John
>.
>|||I like the Copy Wizard myself.
Put database in single user mode.
Right click on server in ent. mgr, then do all tasks/Copy
Database Wizard.
>--Original Message--
>Our client has an SBS 2000 server with SQL 2000
installed.
>The server has 3 separate physical hard drives. I am
>moving the data to a new server with 1 large physical
hard
>drive. My question is what is the easiest method to move
>the data from the old server to the new server, keeping
in
>mind that the partions are changing. I don't want to
>create the partions on the new server.
>Thanks for the help,
>John
>.
>|||Here are some good articles:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"John Chase" <johnc@.hcd.net> wrote in message news:06a001c39efe$b1f08e80$a001280a@.phx.gbl...
> Our client has an SBS 2000 server with SQL 2000 installed.
> The server has 3 separate physical hard drives. I am
> moving the data to a new server with 1 large physical hard
> drive. My question is what is the easiest method to move
> the data from the old server to the new server, keeping in
> mind that the partions are changing. I don't want to
> create the partions on the new server.
> Thanks for the help,
> John