The following script can be ran against your Playback Database to remove data older that 14 days. The change the days to delete, change the -14 value.
use [SpotlightPlaybackDatabase]
declare @date datetime;
set @date=DATEADD(day,-14,GETDATE());
begin tran
SET IDENTITY_INSERT [spotlight_playback_data] on
select [pb_id]
,[pb_domain_name]
,[pb_timestamp]
,[pb_me_name]
,[pb_package_name]
,[pb_table_name]
,[pb_data]
,[pb_data_compressed] into [#TMP_spotlight_playback_data] from [spotlight_playback_data] where [pb_timestamp] > @date
truncate table [spotlight_playback_data];
SET IDENTITY_INSERT [spotlight_playback_data] on
insert into [spotlight_playback_data] ([pb_id]
,[pb_domain_name]
,[pb_timestamp]
,[pb_me_name]
,[pb_package_name]
,[pb_table_name]
,[pb_data]
,[pb_data_compressed]) select [pb_id]
,[pb_domain_name]
,[pb_timestamp]
,[pb_me_name]
,[pb_package_name]
,[pb_table_name]
,[pb_data]
,[pb_data_compressed] from [#TMP_spotlight_playback_data]
SET IDENTITY_INSERT [spotlight_playback_data] off
drop table [#TMP_spotlight_playback_data]
SET IDENTITY_INSERT spotlight_playback_strings on
select [pb_string_id]
,[pb_hash_key]
,[pb_string_compressed]
,[pb_last_used] into [#TMP_spotlight_playback_strings] from [spotlight_playback_strings] where [pb_last_used] > @date
truncate table [spotlight_playback_strings];
SET IDENTITY_INSERT [spotlight_playback_strings] on
insert into [spotlight_playback_strings] ([pb_string_id]
,[pb_hash_key]
,[pb_string_compressed]
,[pb_last_used]) select [pb_string_id]
,[pb_hash_key]
,[pb_string_compressed]
,[pb_last_used] from [#TMP_spotlight_playback_strings]
SET IDENTITY_INSERT [spotlight_playback_strings] off
drop table [#TMP_spotlight_playback_strings]
commit
