Steps are:
- Suspend your database to close data movements
- Change Readable secondary Nodes to “NO”
- Move Your Datafiles
- Alter database <database_name> MODIFY FILE (NAME = <logical file_name>, FILENAME = <physical_file_name>)
- Close SQL Service
- Move Datafiles to specified path
- Open Database Service
- Check everything is OK
- Resume your Database to activate Data flow
- Change readable to “YES”
No responses yet