Can we backup to Stream

When we use the SQL to backup a database, we use:
backup database Health to disk='c:\Backup.bak' with init
This will generate a physical file in disk.

Can we backup file to a Stream?

Scott
Sat Aug 26 19:24:12 CDT 2006

Sure, but why would you want to?


"ad" <flying@wfes.tcc.edu.tw> wrote in message
news:O30BRTWyGHA.1256@TK2MSFTNGP04.phx.gbl...
> When we use the SQL to backup a database, we use:
> backup database Health to disk='c:\Backup.bak' with init
> This will generate a physical file in disk.
>
> Can we backup file to a Stream?
>

ad
Sat Aug 26 22:47:38 CDT 2006


When I use the asp.net to backup database, for example use
backup database Health to disk='c:\Backup.bak'
it will result in an error : No access right to c:\

So, I want to backup it up to a stream and download it to client.



"Scott M." <s-mar@nospam.nospam> ¼¶¼g©ó¶l¥ó·s»D:uIORp6WyGHA.3464@TK2MSFTNGP03.phx.gbl...
> Sure, but why would you want to?
>
>
> "ad" <flying@wfes.tcc.edu.tw> wrote in message
> news:O30BRTWyGHA.1256@TK2MSFTNGP04.phx.gbl...
>> When we use the SQL to backup a database, we use:
>> backup database Health to disk='c:\Backup.bak' with init
>> This will generate a physical file in disk.
>>
>> Can we backup file to a Stream?
>>
>
>

Miha
Sun Aug 27 02:56:43 CDT 2006

Hi,

I don't think it is supported, however you might try one of these:
- backup to a temp folder and load it into stream
- use .net within sql server (2005) and do the magic there

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"ad" <flying@wfes.tcc.edu.tw> wrote in message
news:%23ZM3SuYyGHA.3440@TK2MSFTNGP06.phx.gbl...
>
> When I use the asp.net to backup database, for example use
> backup database Health to disk='c:\Backup.bak'
> it will result in an error : No access right to c:\
>
> So, I want to backup it up to a stream and download it to client.
>
>
>
> "Scott M." <s-mar@nospam.nospam>
> ¼¶¼g©ó¶l¥ó·s»D:uIORp6WyGHA.3464@TK2MSFTNGP03.phx.gbl...
>> Sure, but why would you want to?
>>
>>
>> "ad" <flying@wfes.tcc.edu.tw> wrote in message
>> news:O30BRTWyGHA.1256@TK2MSFTNGP04.phx.gbl...
>>> When we use the SQL to backup a database, we use:
>>> backup database Health to disk='c:\Backup.bak' with init
>>> This will generate a physical file in disk.
>>>
>>> Can we backup file to a Stream?
>>>
>>
>>
>
>

Scott
Sun Aug 27 10:21:54 CDT 2006

I'd say find the cause of your permissions problem, rather than change the
architecture of your application for the worse.


"ad" <flying@wfes.tcc.edu.tw> wrote in message
news:%23ZM3SuYyGHA.3440@TK2MSFTNGP06.phx.gbl...
>
> When I use the asp.net to backup database, for example use
> backup database Health to disk='c:\Backup.bak'
> it will result in an error : No access right to c:\
>
> So, I want to backup it up to a stream and download it to client.
>
>
>
> "Scott M." <s-mar@nospam.nospam>
> ¼¶¼g©ó¶l¥ó·s»D:uIORp6WyGHA.3464@TK2MSFTNGP03.phx.gbl...
>> Sure, but why would you want to?
>>
>>
>> "ad" <flying@wfes.tcc.edu.tw> wrote in message
>> news:O30BRTWyGHA.1256@TK2MSFTNGP04.phx.gbl...
>>> When we use the SQL to backup a database, we use:
>>> backup database Health to disk='c:\Backup.bak' with init
>>> This will generate a physical file in disk.
>>>
>>> Can we backup file to a Stream?
>>>
>>
>>
>
>

Cor
Sun Aug 27 10:50:45 CDT 2006

I assume that you mean in other words, "make a service running at the
Administrator or system account that moves the file to a folder to which the
ASPNET account has rights to read from".

Cor

"Scott M." <s-mar@nospam.nospam> schreef in bericht
news:ujZyRweyGHA.2392@TK2MSFTNGP03.phx.gbl...
> I'd say find the cause of your permissions problem, rather than change the
> architecture of your application for the worse.
>
>
> "ad" <flying@wfes.tcc.edu.tw> wrote in message
> news:%23ZM3SuYyGHA.3440@TK2MSFTNGP06.phx.gbl...
>>
>> When I use the asp.net to backup database, for example use
>> backup database Health to disk='c:\Backup.bak'
>> it will result in an error : No access right to c:\
>>
>> So, I want to backup it up to a stream and download it to client.
>>
>>
>>
>> "Scott M." <s-mar@nospam.nospam>
>> ¼¶¼g©ó¶l¥ó·s»D:uIORp6WyGHA.3464@TK2MSFTNGP03.phx.gbl...
>>> Sure, but why would you want to?
>>>
>>>
>>> "ad" <flying@wfes.tcc.edu.tw> wrote in message
>>> news:O30BRTWyGHA.1256@TK2MSFTNGP04.phx.gbl...
>>>> When we use the SQL to backup a database, we use:
>>>> backup database Health to disk='c:\Backup.bak' with init
>>>> This will generate a physical file in disk.
>>>>
>>>> Can we backup file to a Stream?
>>>>
>>>
>>>
>>
>>
>
>

Cor
Sun Aug 27 11:09:22 CDT 2006

I forgot the ;-)

Cor

"Cor Ligthert [MVP]" <notmyfirstname@planet.nl> schreef in bericht
news:ud5qhBfyGHA.4104@TK2MSFTNGP02.phx.gbl...
>I assume that you mean in other words, "make a service running at the
>Administrator or system account that moves the file to a folder to which
>the ASPNET account has rights to read from".
>
> Cor
>
> "Scott M." <s-mar@nospam.nospam> schreef in bericht
> news:ujZyRweyGHA.2392@TK2MSFTNGP03.phx.gbl...
>> I'd say find the cause of your permissions problem, rather than change
>> the architecture of your application for the worse.
>>
>>
>> "ad" <flying@wfes.tcc.edu.tw> wrote in message
>> news:%23ZM3SuYyGHA.3440@TK2MSFTNGP06.phx.gbl...
>>>
>>> When I use the asp.net to backup database, for example use
>>> backup database Health to disk='c:\Backup.bak'
>>> it will result in an error : No access right to c:\
>>>
>>> So, I want to backup it up to a stream and download it to client.
>>>
>>>
>>>
>>> "Scott M." <s-mar@nospam.nospam>
>>> ¼¶¼g©ó¶l¥ó·s»D:uIORp6WyGHA.3464@TK2MSFTNGP03.phx.gbl...
>>>> Sure, but why would you want to?
>>>>
>>>>
>>>> "ad" <flying@wfes.tcc.edu.tw> wrote in message
>>>> news:O30BRTWyGHA.1256@TK2MSFTNGP04.phx.gbl...
>>>>> When we use the SQL to backup a database, we use:
>>>>> backup database Health to disk='c:\Backup.bak' with init
>>>>> This will generate a physical file in disk.
>>>>>
>>>>> Can we backup file to a Stream?
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Otis
Sun Aug 27 12:39:08 CDT 2006

On Sun, 27 Aug 2006 07:10:13 +0800, "ad" <flying@wfes.tcc.edu.tw> wrote:

>When we use the SQL to backup a database, we use:
>backup database Health to disk='c:\Backup.bak' with init
>This will generate a physical file in disk.
>
>Can we backup file to a Stream?
>
And I repeat Scot M.'s.'s question in a modified manner. Why would you want to
let someone use a web site to backup a database??? Seems like an invitation for
someone to compromise the database. Just my opinion I could be wrong.
Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com