Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Aug 13 '10 at 13:29

This question came from our site for professional and enthusiast programmers.

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. – Mitch Wheat Aug 13 '10 at 13:23
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. – Gennady Vanin Геннадий Ванин 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

share|improve this answer

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

share|improve this answer
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) – Gennady Vanin Геннадий Ванин 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
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 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.