CODEWITHSUNDEEP
sql-server
Gopal
Gopal

Reputation: 11972

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

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.

Upvotes: 1

Views: 111

Answers (1)

Raptor
Raptor

Reputation: 54212

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

Upvotes: 1

Related Questions