Traccar database maintenance
What do you mean by database maintenance?
The database has been increased to 300 GB, what I need to do is reduce that size but I don't know if deleting the records from the dbo.tc_positions table and the dbo.tc_events affects the operation of traccar since it saves the positions of the gps are updated but it takes up to 2 hours to send the current location the gps are configured to send position every 1 minute
It should not cause any issues. Just make sure you don't remove positions that are referenced from tc_devices table.
What do you mean by positions? So you cannot delete the entire rows of the records?
how can I do what you tell me
good day to which tables or how the database maintenance is done to traccar the database is mounted on sql server 2012