• You can use a couple of methods including detach / copy / attach or backup / restore. Both are very effective.

    As for the automatic update process, what are you trying to do?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot