Thursday, March 29, 2012

Db Backup

I need to creat SQL Database backup that I can have a user with no SQL serve
r
installed on his/her PC to be able to execute the Backup Job how can I use i
n
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 fro
m
the user.
John
"Omran Abdurrahman" wrote:

> I need to creat SQL Database backup that I can have a user with no SQL ser
ver
> installed on his/her PC to be able to execute the Backup Job how can I use
in
> exe.
> thanks,
> Omransql

No comments:

Post a Comment