Migration of SQL Server to a Separate server

[Former Member]

Dear Gurus,

We would like to move the MS SQL database to a separate server and use the current server as application layer.

Please suggest the simplest method to Migrate the database. Versions are same , However , the new server OS is 64 bit, current OS version is 32 bit.

Thanks and regards

Vagesan

[Former Member]

Hi Vagesan,

Take a DB Backup of Current Server and Restore the DB Backup of

New Server

Regards

Jambulingam.P

[Former Member]

Hi

refer to

http://vyaskn.tripod.com/moving_sql_server.htm

you can do this by attach/deattach or backup/restore

refer to http://support.microsoft.com/default.aspx?scid=kb;en-us;304692

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

Rohit