Backup Only Tool

Hi there,
We have several users that require a tool to make ad hoc backups. Fo
obvious reasons we don't want to give them any other functionality
such as restoring a database. Is there a tool, 3rd party or otherwise,
that would suitable for this?
Any help much appreciated.
Joeit would be very easy to slap together a simple script using dmo/smo that
your users could plug in a server and database name and location and have it
perform a backup.
TheSQLGuru
President
Indicium Resources, Inc.
"joe" <joelocker@.gmail.com> wrote in message
news:1186999278.638852.239050@.57g2000hsv.googlegroups.com...
> Hi there,
> We have several users that require a tool to make ad hoc backups. Fo
> obvious reasons we don't want to give them any other functionality
> such as restoring a database. Is there a tool, 3rd party or otherwise,
> that would suitable for this?
> Any help much appreciated.
> Joe
>|||I would be extremely careful of allowing this unless you have bagloads
of disk space available. it is impossible to manage the number of
backups that could be created which could lead to rapid disk space
usage. if you haven't given much thoguht to your server configuration
and have backups on the same disk space as your databases, you could
very quickly run into the situation where your databases will not have
any available space left to write to.
You may want to instead create a maintenance plan that kept only a
certain number of backups (or certain number of days) and then create
the script to run the maintenance plan to put some more controls in
place on disk space usage.
I will not list specific examples, but you should really consider the
disk space usage and also consider why the users need to backup
databases themselves.|||I wouldn't allow them to do backups on the server - only on their local
machine or a file server that it is ok if they fill up. :-)
TheSQLGuru
President
Indicium Resources, Inc.
"Joe Mama" <Les.Barkhouse@.gmail.com> wrote in message
news:1187100581.123220.126500@.19g2000hsx.googlegroups.com...
>I would be extremely careful of allowing this unless you have bagloads
> of disk space available. it is impossible to manage the number of
> backups that could be created which could lead to rapid disk space
> usage. if you haven't given much thoguht to your server configuration
> and have backups on the same disk space as your databases, you could
> very quickly run into the situation where your databases will not have
> any available space left to write to.
> You may want to instead create a maintenance plan that kept only a
> certain number of backups (or certain number of days) and then create
> the script to run the maintenance plan to put some more controls in
> place on disk space usage.
> I will not list specific examples, but you should really consider the
> disk space usage and also consider why the users need to backup
> databases themselves.
>