• rray 44280 (6/10/2013)


    I'm happy to do it via the backup and restore method, and that seems to be the approach I see discusse most often. Thanks!

    Well, detaching and attaching is a good option if you don't need to move the data and log files around the network. It's all a question of time. If it's quick enough to do a backup and restore then by all means take that approach.

    Just make sure your backups are in order if you try doing the detach/attach. Not being a doomsayer, just advising caution wherever possible.