Sample Header Ad - 728x90

How to move mdf file to other disk drive when it is "Standby / Read-Only" mode?

1 vote
1 answer
656 views
I am trying to change the location of mdf and ldf file from one disk drive to other disk drive due to storage limit. Currently, the database that I am trying to move to other drive is in "Standby / Read-Only" mode. But, my understanding is that, in order move mdf file and attach database, I need to change the mode to "regular" before moving. Also, my understanding is that if I change the mode from "Standby / Read-Only" mode to something else, I cannot go back to restoring without restoring the backups again. How do I go about doing it (attaching the "Standby / Read-Only" database after detaching)?
Asked by Java (253 rep)
Mar 21, 2023, 10:12 PM
Last activity: Mar 22, 2023, 02:54 PM