Monday 7 January 2013

How to handle Log full issue

How to handle Log full issue :-

1. select * from syslogshold
    go
2. sp_who '100'
    go
3. sp_showplan '100' , null,null,null
go
4.  dbcc sqltext(100)
go
5.kill 100
6.  re-run query in small batch to prevent log full issue.