How to download a backup copy of a MS SQL database?

Before I get flamed let me just say that I have searched Google and these forums on how to do this and I cannot find anything on what to do.

I would like to download a copy of an MS SQL database that is at a hosting provider and upload it to another provider. I can log in using Enterprise Manager but I cannot figure out how to get a copy of what I need so I can move it over to a new site. If somebody can give me a list of steps of what I need to do to download everything off the old server and what I need to do to upload it to the new one, I would be really appreciative.

Can somebody please answer this??

I'm not sure if this works in the full version of MSQL but i have used it in MSDE which is MS SQL7 'lite'.


. Open the DOS prompt. You can do this by clicking 'Run' on the 'Start' menu and typing "cmd" in the 'Open' box.

3. Type the following command in the DOS window:

"OSQL -Usa -Ppassword -n -Q "BACKUP DATABASE CE85 TO DISK = 'c:\CE85.dat_bak'""

Having said that if you have enterprise manager on your machine you can right click the database | "all task" | backup database. you should be able to figure it out from there.

R.

better solution works with SQL2000

1-open Entreprise Manager
2-right click the DB in question go to all task ->detach database(make sure nodoby is in it)
3- once detach, find the files(.MDF AND .LDF) in Explorer
4-copy it to the new provide
5- re-attach the DB, right click on databases and go to all taks -> attach Db
6-find you DB and simply press ok
7-do that again for your new provide