Re: On demand backups

From: _M_ (here_at_gone.com)
Date: 08/13/03 

Date: Wed, 13 Aug 2003 13:59:49 -0400

Ok.... after looking at the SQL server, it appears that the accounting app is using a Login ID, that in turn is the dbo for the accounting database, so I have given that ID the Backup DB permission on the server. Now what can I do to place a short cut on the desktops so that the database is backed up when click (thus on demand). Is there a script file that I need to write or a command line to be entered ???

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message news:us9V7HcYDHA.656@tk2msftngp13.phx.gbl...
  An app with the sa password is like a 3-yr old with a .357 magnum. Your accounting app should not have sysadmin rights. You can grant BACKUP DATABASE to any login and that's all you would need for that.

  --
  Tom

  ---------------------------------------------------------------
  Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
  SQL Server MVP
  Columnist, SQL Server Professional
  Toronto, ON Canada
  www.pinnaclepublishing.com/sql

  "_M_" <here@gone.com> wrote in message news:#KbMuEcYDHA.2464@TK2MSFTNGP09.phx.gbl...
  Have a client that needs to do an "on demand" back up of a database. How
  can this be done ???

  The database in question is used by the accounting department and the
  application uses the SA login to access the database.

  Any insight would be greatful.

  TIA

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
Quantcast