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

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.