Cari Blog Ini

13 Juni 2012

ODBC SQLState: 420000 - RESTORE DATABASE is terminating abnormally


Error Messages:

Microsoft SQL-DMO (ODBC SQLState: 420000) 

Exclusive access could not be obtained because the database is in use. 

RESTORE DATABASE is terminating abnormally.








It happened because:
* the database is still in use by user.

Solution:
You could
1. detach the database
2. attach again the database
3. then restore again the database.