Knowledgebase
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.
2014-06-23 14:19:16.81 spid53 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.

 

For the error above you need to 

 

1. remove old data

2. shrink db.

 

query to get row count

USE bprodata
GO
SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count
FROM sys.dm_db_partition_stats st
WHERE index_id < 2
ORDER BY st.row_count DESC
GO

 

one query to cull data is:

delete from log_tran

where ddate <= '2013-12-31'

 

 

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: