Msg 952, Level 16, State 1, Line 1 Database is in transition offline database to online

I got the below error message when i am trying to bring the offline database to online.

Msg 952, Level 16, State 1, Line 1 Database 'xxxxxxx' is in transition.

Below solution worked for me, It may varies from environment to environment

Try to access the database from SSMS, If it gives same error message then restart the SSMS,

Sometimes restart SSMS will fix the issue, If not issue the below comand

select spid, db_name(dbid) from master..sysprocesses where dbid = dbid('db_name')

Verify are there any spids which is trying to access the database,

Issue kill on that SPID, then database will become offline

bring the database online, it works for me