How to move the database from one server to another server?

Question

Using SQL Server 2005

I attached the database in Windows authentication Mode, then it detach the database, and then i try to attach the same database in sql authentication mode. It showing error as "cannot create a sysindex"

The database was created in windows authentication mode, It is working in all windows authentication mode. It was not able to attach in SQL Server Authentication mode.

How to solve this issue.

Answer 1

Look here: http://www.sqlteam.com/forums/topic.asp?TOPIC%5FID=91687 and here: http://msdn.microsoft.com/en-us/library/ms189128.aspx

Answer 2

instead of detaching the database, pause all transactions and backup the database. Restore it on other machine. That should work.