What is the best way to do this? File locations will be different on new server.<BR><BR>Should I SP_DETACH_DB the source DB, copy over the .mdf/.ldf files, then SP_ATTACH_DB on destination server with ...

I've only have a redumentry background with SQL 2000 and I would like some advice. I'll get to the point. A guy has a SQL 2000 server with a database that contains a whack of information that is ...