I have a MSSQL databse hosted on a windows server, What do I need to download a back up to my pc? I am familiar with backing up MSSQL databases, I believe I need to download a Microsoft database management program is this correct?

  • 11
    If you expect people to invest their time answering your question, YOU should invest some time in asking the question. Your question is broad and tells us nothing about which specific problems you are facing. Aug 13 '10 at 13:23
  • 1
    Hi, user40709, I voted you up. Do not discourage yourself just because half a dozen guys here earned here big scores to pass time downvoting people who have doubts and questions. If to ultimately to formulate correctly the question then it would not contain even anything to ask. Aug 13 '10 at 15:06
  • downvote here, too. Same argument as Mitch Wheat.
    – TomTom
    Aug 15 '10 at 14:49

IF you want to restore the backup to your PC you will need a copy of the SQL database endine running and a copy of SQL management studio installed. Check out SQL Server Express


One can restore (added later - or backup) database from command line. The advantage of this is that it does not require SSMS (MS SQL Server Management Studio) setup. I sure you find a plethora of articles to choose from according to your taste through "googling" (searching on internet)

Look for SqlCmd in BOL or internet to backup/restore from command line

  • 1
    He's looking to backup, not restore...
    – DanBig
    Aug 13 '10 at 13:59
  • He is looking "download a back up to my pc?' obviously to restore then. Though what is the difference? backup/restore are symmetrical paired activities done by the same tools or approaches approaches (there is no backup without restore and no restore without backup) Aug 13 '10 at 14:13
  • Backup and restore are two distinctly different tasks. Both have very different sets of steps. Backups can exist without restores but restores cannot exist without a backup. They are also not necessarily done with the same set of tools.
    – GregD
    Aug 13 '10 at 14:27
  • Instead of telling someone to google it, you could instead provide links to some of the information you're telling them to google for.
    – GregD
    Aug 13 '10 at 14:28
  • 2
    your answers, and subsequent comments to others are becoming increasingly irritating. We don't know that he is "obviously trying to restore", because it wasn't stated.
    – DanBig
    Aug 13 '10 at 15:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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