• ensure the sql service account has full control permissions on the E:\sqldata directory.

    You will need to restart the instance for the change to take effect.

    Delete the old files after successful move.

    You cannot backup tempdb so not sure what you mean by that.

    ---------------------------------------------------------------------