Sql-server – Delete unused index on report server

disk-spacereplicationsql server

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.

Best Answer

Yes, you can drop the indexes on the subscriber if no one is using them. Better yet, remove them from the publication article, or create a post snapshot script to drop whatever indexes you want. Either way on next initialization, the indexes will not be created, or they will be dropped.