In my environment I need to copy a database from one server to another. Usually a QA machine to my local box.
I do not have access to QA machine. I can connect to the database, but not RDP into the box.
What is the best way to copy the database from the QA server to my machine?
Best Answer
I would try the Copy Database Wizard command available through SQL Management Studio. This can be done without RDP access.
Microsoft also has an MSDN page on copying data between servers that may be helpful.