Backup DB from a Client Workstation

[squishiddy]

Hi Everyone.

I need to give my users access to manually backup a database on the SQL Server from their workstation.

My users currently have full administrative rights and open a remote desktop connection to SQL Server and run a script on the desktop to create a backup of the database.

Is it possible to run this script from their workstation?

I don't want them to accidentally mess anything up given they must have full admin rights to do a backup.

Script:

"c:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmaint.exe" -S (local)\ -D TESTDB -BkUpDB c:\sqldata\mssql\backup\TESTDB1 -BkUpMedia DISK -VrfyBackup

Thanks a bunch in advance to anyone that can help!!!

~o)

 

[nigelrivett]

????
Look at backup database in bol.
Also look at db_backupoperator role.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Corran007]

If you install the client tools on the workstation you can use the osql utility. Look at it in bol. It allows you to run commands against a sql database. You will proably have to rewrite your command though.