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
No comments:
Post a Comment