Fixing space issue on SQL express
Posted by Lloyd Jansen on 23-06-2014 02:35 PM
2014-06-23 14:19:16.81 spid53 Error: 1827, Severity: 16, State: 1.
For the error above you need to
1. remove old data
2. shrink db.
query to get row count
one query to cull data is:
delete from log_tran
where ddate <= '2013-12-31'