(UCMDB SUPPORT TIP) - SQL Server Issues Due to Space - high number of records in sync_id_map
Is it possible to drop the sync_id_map table to resolve space issues piece by piece or there are mandatory relations in this table to other tables ?
1) It is ok to drop only that table piece by piece and should not affect other tables . Typical SQL would be :
DELETE top(1000000) FROM [dbo].[SYNC_ID_MAP] WHERE DS_ID = 22
SELECT COUNT(*) FROM [dbo].[SYNC_ID_MAP]
2) Also if a customer is using the Full Recovery model in their database setup , the transaction logs could be taking up a lot of the space. ? Ticking the "Truncate the transaction log" check box on the Back Up Database screen of the MS SQL GUI could help here .
Please note that all deletions and truncations are the responsibilty of the customer and any truncations or deletions must always be preceeded by a full , easily - recoverable database backup.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Please hit the Kudo botton, if you find this post useful.