Database backup from the application code ...

  • Thread starter Thread starter Tamer Ibrahim
  • Start date Start date
T

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.
 
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.
Click to expand...

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.
 
Back
Top