How do I make a database backup and have it stored locally?

I'm guessing you're talking about SQL Server, based on the TSQL example- to which I'd recommend checking out DMO objects. Here's a primer http://www.codersource.net/csharp%5Fsqldmo%5Fsqlserver.aspx Truthfully- the vague nature of your question- and the fact that it's context free gives me some heebie jeebies. Be sure to test in a test envrionment and not run on production data, ok?

I'm guessing you're talking about SQL Server, based on the TSQL example- to which I'd recommend checking out DMO objects. Here's a primer- http://www.codersource.net/csharp%5Fsqldmo%5Fsqlserver.aspx. Truthfully- the vague nature of your question- and the fact that it's context free gives me some heebie jeebies.Be sure to test in a test envrionment and not run on production data, ok?

The backup system of SQL Server runs the entire backup procedure on the server, which basically means that the file has to be put somewhere the database server can put it and has access to. In other words, the file will be written from the server. If you: Cannot access files directly on the server, from the client, in any way Cannot download files from the server, to the client, in any way Cannot write files from the server, to a common place, that is reachable by the client in any way Then you are left with one way: Reimplement backup.

If your actual question is this: With all of that in mind...anyone done something like this and care to share? Then I'm going to hazard a guess that the answer to this question is: No. Are you sure you cannot change the problem to one that is solvable?

I actually think I might have it figured out. Code.google. Com/p/roundhouse/issues/detail?

Id=3 – ferventcoder Nov 16 '09 at 22:45.

Think I actually have figured out what we are going to do: Create a special folder in the AppData area of the current user. Create a fileshare to that folder Add rights to Everyone for that particular share and folder. Process the backup based on that share.

Remove the share and reset the permissions. In case anyone is curious what this question refers to: RoundhousE.

If you want/need to back up a database, then in general, for the purpose of guaranteed database consistency, the database server will need to be either completely shut down, or at least be completely in read-only mode. Your question sounds like your "challengers" have taken you to task to back up a remote server while none of those conditions are satisfied. The only sensible answer to such a challenge is that it cannot be done.

Most database engines today allows for a hot backup which will be consistent. – Lasse V. Karlsen?

Nov 15 '09 at 23:38 If the OP has the "hotbackup" facility of his DBMS to his avail, then he wouldn't have had to ask the question. Once again a moronic downvote by an idiot who doesn't bother to read the question (the keyword was "remote"), nor to think about the answer. Thanksalot.

– Erwin Smout Nov 16 '09 at 0:29 OH, and I almost forgot the other keyword, "backup remote server, backup STORED LOCALLY". – Erwin Smout Nov 16 '09 at 0:34 I didn't vote you down... but to be clear, I want to do an automated database backup from a remote server and don't have access to the remote file system. I would like to have the backup be stored locally.

I don't want the . Mdf file, I want the . Bak (think SQL server for now).

– ferventcoder Nov 18 '09 at 16:13.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.