restore database [数据名称] with recovery
ALTER DATABASE [数据名称] SET OFFLINE WITH ROLLBACK IMMEDIATE
---select object_id,session_id,locked_mode from v$locked_object;
--select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
--from sys.dm_tran_locks where resource_type='OBJECT'
--kill 4