Move Database to new Server

I would like to move a database to a different server. What would be the
best route for this. I am pretty new to this and don't want to mess it up.
Thanks in advance,
Gregdid you hear "examnotes" <Greg@.discussions.microsoft.com> say
in news:0075FE80-A7CD-4D42-8974-EEB3C5CAC806@.microsoft.com:

> I would like to move a database to a different server. What would be
> the best route for this. I am pretty new to this and don't want to
> mess it up.
> Thanks in advance,
> Greg
>
try looking in BOL for the copy database wizard. It's pretty good at
"hand holding" and so long as no on is in teh database when you do it,
works very cleanly. (tools -> wizards -> management -> copy database
wizard)
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||Hi,
2 approaches:-
I.
1. SP_DETACH_DB DBNAME
2. Move the .mdf and .ldf files to new server
3. SP_ATTACH_DB dbanme,@.filename1='',@.filename_2=''
or else you can move a database using below steps,
II.
1. Do a Backup of database
2. Copy the .BAK file to new server
3. Restore the database
see below link for more details:-
http://support.microsoft.com/defaul...kb;en-us;314546
Thanks
Hari
SQL Server MVP
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:0075FE80-A7CD-4D42-8974-EEB3C5CAC806@.microsoft.com...
>I would like to move a database to a different server. What would be the
> best route for this. I am pretty new to this and don't want to mess it
> up.
> Thanks in advance,
> Greg
>