Unanswered: Take database from one machine to another
I'm sure this is a lame question to some of you... but I'm sysadmin, not db.... Now that I have thrown out my safety net...
What is the best way to get a database off a slower machine to another machine. SQL7 is installed on both machines. They are both on the net. The older machine will be tossed after I get the db off of it.
Is this just a matter of copying the file off or should I import or something.
Remember to break out the crayons and draw me a picture when you reply. Thanks in advance.