Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How Can I backup An Sql Server Database To My Local Drive From Remote Server

share|improve this question
add comment

2 Answers

You can run a 'generate script' task from within SSMS that allows you to save it to disk local to where SSMS is running from. It's not a 'SQL Server Backup' in the traditional sense, but it is a backup of data.

If you need a .bak file that's an actual 'backup', you need to save it local to the SQL server and copy it.

share|improve this answer
    
The other alternative is to share a directory from your computer and make sure the SQL Server service account has permission to write to it. Then you can back up to the share directly. (We did this for a while to write backups to a remote server.) But for a quick one-time backup that you need to run, it's probably more trouble than it's worth. Just make a local backup, and move the .bak file to your machine when it's done. –  db2 May 10 '11 at 12:22
add comment

If you need to do it every (hour,day,week) make a dump using the special script (you may find lots of them in the internet) and download the last dump to you local drive.

Another way is to use software specializing in that - Handy Backup or Acronis, they can backup your DB remotely to wherever you want, I don't know exactly how they backup to local drive, I mean, whether they store in aproprietary format or not, but Handy Backup can store backups online, so you will be able to get dumps via ftp from their servers.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.