Information is stored somewhere. Sometimes it’s not suited for its original location. If you’re running low on disk space, added a new drive array, or just curious; this is a simple procedure to move ...
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 ...
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 ...