SqlServer 清空日志

USE [master]   ALTER DATABASE his2020 SET RECOVERY SIMPLE WITH NO_WAIT   ----blog为需要清除日志的数据库名称   ALTER DATABASE his2020 SET RECOVERY SIMPLE   --简单模式   ----blog为需要清除日志的数据库名称   USE his2020     ----blog为需要清除日志的数据库名称   DBCC SHRINKFILE (N‘his2020_Log‘ , 11, TRUNCATEONLY)    ----blog_Log为需要清除日志的数据库名日志名称   USE [master]   ALTER DATABASE his2020 SET RECOVERY FULL WITH NO_WAIT   ----blog为需要清除日志的数据库名称   ALTER DATABASE his2020 SET RECOVERY FULL  --还原为完全模式   ----blog为需要清除日志的数据库名称

<span style="color: #0000ff;">--查锁表进程<br>select</span><span style="color: #000000;"> request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName   
</span><span style="color: #0000ff;">from</span> sys.dm_tran_locks <span style="color: #0000ff;">where</span> resource_type=<span style="color: #800000;">‘</span><span style="color: #800000;">OBJECT</span><span style="color: #800000;">‘</span>
<br>--杀进程
declare @spid  <span style="color: #0000ff;">int</span> 
Set @spid  = <span style="color: #800080;">101</span> --<span style="color: #000000;">锁表进程
</span>declare @sql varchar(<span style="color: #800080;">1000</span><span style="color: #000000;">)
</span><span style="color: #0000ff;">set</span> @sql=<span style="color: #800000;">‘</span><span style="color: #800000;">kill </span><span style="color: #800000;">‘</span>+cast(@spid  <span style="color: #0000ff;">as</span><span style="color: #000000;"> varchar)
</span>exec(@sql)

--<span style="color: #000000;">已存在表 os_operator
insert into os_operator(ope_code,open_mac,myrloe_code,rloe_code) </span><span style="color: #0000ff;">select</span> pass_operator,<span style="color: #800080;">1</span>,<span style="color: #800000;">‘</span><span style="color: #800000;">[]</span><span style="color: #800000;">‘</span>,<span style="color: #800080;">0</span> <span style="color: #0000ff;">from</span> ITSV.his.dbo.aps_operator_pass<br><br>--不存在表 os_operator<br>select * into os_operator from ITSV.his.dbo.aps_operator_pass

 

SqlServer 清空日志

标签：pen   from   模式   iat   use   存在   trunc   insert   ase