Database backup from the application code ...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tamer Ibrahim - 04 Jun 2007 01:16 GMT

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.

Reply to this Message

Matt Lacey - 04 Jun 2007 12:33 GMT

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

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...