Thursday, March 29, 2012

Db Backup

I need to creat SQL Database backup that I can have a user with no SQL server
installed on his/her PC to be able to execute the Backup Job how can I use in
exe.
thanks,
OmranHi
You can write a program in ADO or ADO.NET that will execute the backup
command for you.
Alternatively you can set up a SQL Agent job on the server that will
automatically backup the database at a given time/date. Check out the backup
database wizard or maintenance plans. This would require no intervention from
the user.
John
"Omran Abdurrahman" wrote:
> I need to creat SQL Database backup that I can have a user with no SQL server
> installed on his/her PC to be able to execute the Backup Job how can I use in
> exe.
> thanks,
> Omran

No comments:

Post a Comment