up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
75% accept rate
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. – WebMAOhist Aug 13 '10 at 15:06
downvote here, too. Same argument as Mitch Wheat. – TomTom Aug 15 '10 at 14:49
feedback

migrated from stackoverflow.com Aug 13 '10 at 13:29

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

3 Answers

up vote 1 down vote

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

link|improve this answer
feedback
up vote 0 down vote

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

link|improve this answer
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) – WebMAOhist 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
feedback
up vote -3 down vote

http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html

this link very helpful for you

link|improve this answer
1  
MSSQL is not MySQL – nos Aug 13 '10 at 13:29
feedback

Your Answer

 
or
required, but never shown
discard

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