October 29, 2010 at 1:14 am
Hi
I have VPN connection for my client, i can access my client server now.
Recently company installed SQL server 2005.
Now i want copy the my client database into my local server.
How can i do that?????????????????
Any help that's great
Thanks in advance
Sank
October 29, 2010 at 5:29 am
since you have a VPN, your machine is effectively on their network right?
what you'll want to do is fairly straightforward, the process is the same as you would do locally.
connect via SSMS to the client's server.
using SSMS, create a backup; since you don't want to mess up any of their existing maintenance plans, make sure the backup you create is for copy only, and change the name of the backup so you don't overwrite the clients existing file:
after the backup is created, you'll need to access it over the network...browse to \\servername\share\thebackup you created.
from there it's copy and paste....note that if you zip it, because you are on the network, it will take longer...because to zip it it gets copied to your temp directory, created, and then placed back wherever you said the zip should be created, and then maybe even copied from that remote zip location to your computer again... you typically want to have remote desktop access to the server to zip a huge backup, which might be copied as described above, or moved via FTP.
hope that helps.
Lowell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply