• Alter database is the preferred method of doing this. Its safer as the database is never actually removed form the instance so any risk when reattaching is mitigated. Also when you reattach the owner of the database could change, which may cause you an issue.

    Whatever way you do it (and it can be done via backup\restore) having a backup to go back to is sensible.

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