I need to move my database from SQL server 2005 32 bit to SQL server 2005 64 bit Is it Possible? am I missing any logic here? Do I able to achieve this in Transfer Database Task ?

Elams, SQL Server databases are not architecture-specific. You can use Transfer Database Task or you can just backup/restore database if it's not some process you'd have to perform periodically. Regards, Akim

Backup database/Copy backup file/Restore database is your best bet.Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM