6 steps to convert a database from recovery mode to available mode in an emergency situation. __ Database

-6 steps in an emergency to convert a database from recovery mode to available mode (data can be logically wrong.) For example, no commit data will produce inconsistencies)
ALTER DATABASE dbname set Single_user with rollback immediate
go
ALTER DATABASE dbname set emergency with rollback immediate
down
select name, physical_name from Sys.master_files  where database_id=db_id (' db_test ')
go
ALTER DATABASE dbname rebuild log on (name= ' Log_name ', filename= ' Physical_ Name ']
go
ALTER DATABASE dbname set online with rollback immediate
go
ALTER DATABASE dbname set Multi_u Ser with rollback immediate go