I ried shrinking database and datfiles but with no luck still the size is 31 Gb,

i used these,

DBCC SHRINKDATABASE

( msdb);

Hello,

I found this syntax, could you please edit it for my need,

DBCC SHRINKDATABASE

(database_name | database_id | 0

[ ,target_percent ]

...

gui,

I see almost all in green color and says Unallocated, but even if I shrink the files and data the size still stays the same,

No the database size did not change

I got this result,

Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.

thanks, I will update the results when I do it,

OK Thanks a Lot, I will look into it,

can you please get me the query to delete it,

No No it is not an SSIS Server, sorry if I missed it, the issue here is not the drives provision, I just wanted to fix this issue as it...

sysxmitqueueclst3970848397035739348993102231018

sysssispackagesNULL12031203199

sysmail_attachmentsNULL510509433

sysobjvaluesclst41838832933

syscollector_blobs_internalPK_syscollector_blobs_internal_paremeter_name120120100

Space is the issue, I do not have much for it on the other drives either,

This did not help because I purged the history and even the 4 weeks did not do any help to the cause,

Hello,

I get this error The SaveToServer method has encountered OLE DB error code 0x80040E14 (Could not allocate space for object 'dbo.sysssispackages' in database 'msdb' beacause the 'PRIMARY' filegroup is full.

dbosysjobactivity12962001521632

dbosysjobhistory1000338421761281080

dboMSdbms_datatype_mapping4934832160

dboMSdbms_map3745640160

dbosysmail_mailitems277136112168

dboMSdbms_datatype1803216160

dbosysjobsteps107192144480

dbosysmail_log1034024160

dbosyspolicy_facet_events848840480

dbosyspolicy_management_facets7416880

dbosysschedules653216160

dbosysjobs648824640

dbosysjobservers644816320

dbosysjobschedules58328240

dbosysssispackages2196409616240

dbosyscategories2116880

dbosyssessions21328240

dbosysmail_attachments184080406488

dbosyssubsystems12328240

dboMSdbms816880

dbosysmail_configuration716880

dbosysmail_send_retries616880

dbosysmanagement_shared_server_groups_internal5648560

dbosyscollector_config_store_internal516880

dbosysssispackagefolders5488400

dbosyscollector_collection_items_internal57240320

dbosyscollector_collector_types_internal4328240

dbosyspolicy_configuration_internal416880

dbosyscollector_collection_sets_internal3328240

dbosysmaintplan_subplans316880

dbosysoperators3328240

dbosysdtscategories3328240

dbosyscachedcredentials216880

dbosysmail_principalprofile116880

dbosysmail_profile1328240

dbosysmail_servertype116880

dbosysdbmaintplans116880

dbosysmail_server116880

dbosysmail_account1328240

dbosysmail_profileaccount116880

dbosysmaintplan_log116880

dbosysmaintplan_logdetail116880

dbosyscollector_blobs_internal196095280

dborestorehistory0328240

dbolog_shipping_secondaries00000

dbosyspolicy_policy_category_subscriptions_internal00000

dbosysmail_query_transfer016880

dborestorefilegroup016880

dbosysjobstepslogs00000

dbologmarkhistory00000

dbosuspect_pages00000

dbosysmail_attachments_transfer0241680

dbosyspolicy_policy_execution_history_internal00000

dbolog_shipping_primaries00000

dbobackupfile0248160

dbobackupfilegroup0248160

dbobackupset0568480

dbosysoriginatingservers00000

dbosyspolicy_target_set_levels_internal00000

dbosysproxies00000

dbosysdbmaintplan_history00000

dbosyscollector_execution_stats_internal00000

dbobackupmediaset0328240

dbosysproxysubsystem00000

dbosysproxylogin00000

dbobackupmediafamily0408320

dbosyspolicy_target_sets_internal00000

dbosqlagent_info00000

dbosysdownloadlist00000

dbosystaskids00000

dbosysdtssteplog00000

dbolog_shipping_primary_databases00000

dbosyspolicy_policy_categories_internal00000

dbolog_shipping_primary_secondaries00000

dbosyspolicy_conditions_internal00000

dbosysdtstasklog00000

dbosysnotifications00000

dbosysdtspackagelog00000

dbosysdtspackages00000

dborestorefile016880

dbosyspolicy_system_health_state_internal00000

dbosyscollector_tsql_query_collector00000

dbosystargetservers00000

dbosystargetservergroups00000

dbosystargetservergroupmembers00000

dbosysalerts00000

dbosyspolicy_execution_internal00000

dbosysmanagement_shared_registered_servers_internal00000

dbosyspolicy_policy_execution_history_details_internal00000

dbosysssislog00000

dbolog_shipping_monitor_alert00000

dbolog_shipping_monitor_secondary00000

dbosysdbmaintplan_jobs00000

dbolog_shipping_monitor_primary00000

dbosyspolicy_object_sets_internal00000

dbolog_shipping_monitor_history_detail00000

dbolog_shipping_monitor_error_detail00000

dbolog_shipping_secondary00000

dbolog_shipping_secondary_databases00000

dbosyspolicy_policies_internal00000

dbosysdbmaintplan_databases00000

dbosyscollector_execution_log_internal00000