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