Forum Discussion
peter_s
Mar 25, 2020Copper Contributor
Is it possible to add an index to a read-only database?
I was given a read-only (daily log shipped) copy of our production database (updated daily) to do some special reporting and the report needs to be optimized with a new index. However because the dat...
- Apr 11, 2020Simply it is not possible to make indexes on read-only database.
Because it is read-only as it named, a writable operation is not a selectable option.
simple work-around is that you restore one more database for a report and use it for other report too, of-course reported data is only point-in-time of recovered time.
and for original daily log-shipped database just don't touch it unless you can't make maintenance time for creating index.
mcdasa
Apr 11, 2020Copper Contributor
Simply it is not possible to make indexes on read-only database.
Because it is read-only as it named, a writable operation is not a selectable option.
simple work-around is that you restore one more database for a report and use it for other report too, of-course reported data is only point-in-time of recovered time.
and for original daily log-shipped database just don't touch it unless you can't make maintenance time for creating index.
Because it is read-only as it named, a writable operation is not a selectable option.
simple work-around is that you restore one more database for a report and use it for other report too, of-course reported data is only point-in-time of recovered time.
and for original daily log-shipped database just don't touch it unless you can't make maintenance time for creating index.