Saturday, February 25, 2012

Move databases to new server

I need to move databases from one server to another (upgrading equipment).
What is the best way to accomplish this?
Thanks,
JeffHi,
The easy way to move the database is ,
1. SP_DETACH_DB DBNAME
2. Move the .mdf and .ldf files to new server
3. SP_ATTACH_DB dbanme,@.filename1='',@.filename2=''
or else you can move a database using below steps,
1. Do a Backup of database
2. Copy the .BAK file to new server
3. Restore the database
4. Delete the database from old server
Thanks
Hari
MCDBA
"Jeff" <jeffpoling@.yahoo.com> wrote in message
news:OV0RlKizDHA.1524@.TK2MSFTNGP10.phx.gbl...
> I need to move databases from one server to another (upgrading equipment).
> What is the best way to accomplish this?
> Thanks,
> Jeff
>

No comments:

Post a Comment