I have a live server and a report server. The live server, where the application is running, has many indexes. When we create replication all the indexes are also created on the report server.
After 2 months, disk space on the report server is running out, and I have to make some space. I checked all the unused indexes on the report server and found many indexes that have not been used any time in the past two months. But they are required for the live server.
Can we delete those indexes that take unnecessary disk space on the report server as no application is pointing to report server? Will it be ok? I want to be sure before I make the changes.