Database backup from the application code ...

[Tamer Ibrahim]

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.

 

[Matt Lacey]

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.