0

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?

Zoredache
  • 130,897
  • 41
  • 276
  • 420
user40709
  • 151
  • 4
  • 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. – Mitch Wheat 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. – Gennady Vanin Геннадий Ванин Aug 13 '10 at 15:06
  • downvote here, too. Same argument as Mitch Wheat. – TomTom Aug 15 '10 at 14:49

2 Answers2

1

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

Ben Robinson
  • 151
  • 5
0

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

Oskar Duveborn
  • 10,760
  • 3
  • 33
  • 48
Gennady Vanin Геннадий Ванин
  • 687
  • 3
  • 13
  • 28
  • 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) – 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
  • 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