Matt
Mon Jun 04 06:33:40 CDT 2007
On 4 Jun, 01:16, "Tamer Ibrahim" <t.ge...@gmail.com> wrote:
> Hi, The task I want to do is backing up the sql server 2000 database which
> my application connect to from a client machine and saving this backup on
> the server machine. Is it possible to do that ? and if yes what code can I
> write to accomplish this task ? Thank you.
Yes, it's possible. The backup procedure can be performed as a T-SQL
command (see
http://msdn2.microsoft.com/en-us/library/aa225964(SQL.80).aspx)
so look to do this in the same way as you would execute any
statement / perform any query.
The only proviso is that you can have file access to the server you
wish to save the backup on.