|
Error: Could not allocate space for object.
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database. Check size of tables in SQL Server Navigate to Tables folder, hit F7. Add columns for disk space if not shown. Run this command to delete old Journal entries. Store Operations Manager, Connect. Query, or use SQL Management Studio. DELETE FROM Journal WHERE [Time] in SQL Management Studio, shrink files, shrink database. https://jerrywalsh.org/2009/reducing-the-size-of-your-dynamics-rms-database-and-backups-0105.html DELETE FROM journal WHERE time https://drs.kayako.com/article/255-how-can-i-shrink-my-rms-database-to-optimize-performance-and-minimize-backup-file-size Run Administrator, File, Connect, and enter your database connection settings, then click OK. Create a backup by selecting Database, Backup. Do NOT skip this step! If the following procedure fails for any reason you may need to restore the backup. Select Database, Reindex and wait for the process to finish. Select Database, Query and cut and paste following script into the window. Change MYDATABASE to the name of your database file. DECLARE @Database varchar(50) SET @Database = 'MYDATABASE' /* Truncate log */ DUMP TRANSACTION @Database WITH TRUNCATE_ONLY /* Shrink Database */ DBCC SHRINKDATABASE (@Database) Press F5 to run it. When finished exit Administrator and select Yes to save. Name this script "Shrink database". Next time select File, Open for step 4. Repeat this procedure every few months or so to ensure your database is optimized, or when you need to free up space to stay below the MSDE or SQL 2005 Express limits (2G or 4G) or the 10G limit on SQL 2008 R2. Notes: Remove line "DUMP TRANSACTION @Database WITH TRUNCATE_ONLY" if running SQL 2008 R2. To keep database overhead to a minimum, MSDE and SQL 2000 users should also disable AutoClose. You only need to run this script once on your database. EXEC sp_dboption 'MYDATABASE', 'autoclose', 'FALSE' Replace MYDATABASE with your database name. |