copy databse to another server

Hello,,

I backed up my database and it created a BAK file. Now I move this file to other server and trying to restore from it. It is giving me error: Device activation error. Do I have to create database before restoring. I do not have this database available in other server and I need to copy database with all constrains and tables.

Thanks,

no you do not have to create teh database first...
the .bak file sounds corrupted...
back up the db again only this time check the box to validate/verify the file.
HTH,
SQLPoet|||Create the backup and take the .bak file and paste it in the Backup subfolder in Microsoft SQL Server folder under programs before going into Enterprise manager and use the backup and restore wizard and choose the restore from device option. Hope this helps.sqlsql