HELP : How to back up a database on ms sql 2005 studio express

hi

Im using the free version of ms sql 2005 studio express. I can upload databases, edit them and check them etc.

how do I back them up on to my pc, I do not have the server with me, my ms database is hosted on namesco.co.uk hosting.

I know how to right click the database, click task and back up. But I dont know where to back it up?

Whenever I try to back up to somewhere on my c: drive it won't. I think it also only backs up on a .bak files. Which I don't have.

I've looked on the net and it says you need a seperate hard drive or tape drive for back. Do I need to add another hard drive to my pc, if yes what do I format it as. And also how do I get a .bak file?

Here is a screenshot of where I can get to:(you might have to copy and paste them in your browser, there bmp so are big images)

http://www.uktattoostudios.co.uk/images/ms1.bmp

http://www.uktattoostudios.co.uk/images/ms3.bmp

As you can see I dont have a .bak to choose so it comes up this. If I click ok and try and back it up, it says back up complete. However when I go in the folder there is no .bak file

I also read on the net that if there shared databases the hosts are the only ones who can back stuff up, I asked them and they said that I should be able to do it on ms sql studio express.

thanks

dave

Backup folder are relative to the server. So every drive / file dialogue you see during the backup is from the server not from the client.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

hi, ok thanks.

So is there no way users can back up there databases? Sounds a bit stupid really?

Also namesco said I should be able to back it up

|||YOu can, but you will have to transfer the backup somehome on the client computer if you want to have if there.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||In Management Studio, right click on the database name, select Tasks|Backup.|||

hi,

rongolini wrote:

In Management Studio, right click on the database name, select Tasks|Backup.

this sounds difficult, if the server resides in a remote hosting company... as Jens anlready pointed out, the backup still resides on the remote machine and you have the hoster to provide a way (say a remote folder you can access over FTP) to bring it home...

regards