Forum Discussion

peter_s's avatar
peter_s
Copper Contributor
Mar 25, 2020
Solved

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...
  • mcdasa's avatar
    Apr 11, 2020
    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.

Resources