Migration SQLSERVER DB from one server to another Server

Hello,
How to migrate SQLSERVER DB from one server to another Server?
We are planning from Compaq server to Dell and vice versa?
Thx.
-SeenaBackup all databases from one server and restore on the other.
I think BOL has info on how to do this for system databases - if not just do a search.

Also look at detach/attach.

Worth reading up about system databases first.|||Hello,
It is the same as the other member of dBforums explained to you. It is so simple, you need only to backup the database. If you are using MS SQL Server 2000, you'll have to choose the database:
- right click
- all tasks
- backup database
- choose the device to which you want to copy (tape/disk)

Then on the other PC, create these databases manually and:
-choose the newly created DB
-right click
-all tasks
-restore database
-choose the source

Otherwise, you can use the DTS service which is available in SQL Server 2000.

it is so simple to use.

Take cares & good luck!

Alzebdeh
Originally posted by sqlserverdb
Hello,
How to migrate SQLSERVER DB from one server to another Server?
We are planning from Compaq server to Dell and vice versa?
Thx.
-Seena|||The easiest, if you have both computer on-line, is to Detach the databases
and copy the MDF and LDF files into the new server, then attach those files
into new SQl.

"Alzebdeh" wrote in message
news:2441325.1043640789@.dbforums.com...
> Hello,
> It is the same as the other member of dBforums explained to you. It is
> so simple, you need only to backup the database. If you are using MS SQL
> Server 2000, you'll have to choose the database:
> - right click
> - all tasks
> - backup database
> - choose the device to which you want to copy (tape/disk)
> Then on the other PC, create these databases manually and:
> -choose the newly created DB
> -right click
> -all tasks
> -restore database
> -choose the source
> Otherwise, you can use the DTS service which is available in SQL
> Server 2000.
> it is so simple to use.
> Take cares & good luck!
> Alzebdeh
> Originally posted by sqlserverdb
> > Hello,
> > How to migrate SQLSERVER DB from one server to another Server?
> > We are planning from Compaq server to Dell and vice versa?
> > Thx.
> -Seena
> --
> Posted via http://dbforums.com (http://dbforums.com/)