Re: Creating specific users

Simon,

A user does not need to be sysadmin to run backups (such as through Query
Analyze as Uri mentioned), but I believe that Enterprise Manager for SQL
Server 2000 specifically checks for sysadmin in the application.

So, as long as SQL Server 2000 and Enterprise Manager are the tools, I think
you are stuck with this level of access. Perhaps your revised approach will
not be too far away.

RLF

"Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:26A07029-860D-40FB-B382-B064819B3A04@xxxxxxxxxxxxxxxx
The whole backup regime was setup before I joined the company. They use
SQL
jobs to run the SQL backups onto tape. A user has been designated to check
EM
to ensure the tape contents are correct. This will change in the medium
term
as we are looking at how everything is backed up and will probably move to
something like Quest Litespeed. However in the short term I don`t really
want
to change the way things are done, only to change in the future.

"Uri Dimant" wrote:

Simon
Why do the users need to see the backups in EM? The files are located on
filesystem.
Can just users issue BACKUP DATABASE/RESTORE DATABASE... from QA?



"Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A221F70-5B21-4A76-97DF-4BF62A4E4196@xxxxxxxxxxxxxxxx
I have a user who is just responsible for monitoring SQL backups.
However I
seem to have to grant sys admin rights in order for the user to be able
to
see the backups in Enterprise manager. What is the lowest level that I
can
grant to the user in this situation ?

Si





.

Relevant Pages

  • Unable to restore *.BAK files from NTBackup
    ... I cannot restore the SQL *.BAK files (created using enterprise manager) ... from tape to either the original or alternate location. ... I can restore them from existing disk backups with SQL manager. ...
    (microsoft.public.windows.server.sbs)
  • Re: Location of Data
    ... > As far as SQL backups, use SQL Enterprise manager to do at least daily ... > backups to your D drive and then let your Backup program bakup the SQL .bak ...
    (microsoft.public.windows.server.sbs)
  • Re: MSDE OSQL Shutdown
    ... dann den Server herunterfährst könnte genau in dem Moment die Aktion ... Aus Gründen der Datenkonsistenz sollten Datenbanken niemals Offline ... weil alle Backups dazwischen unbrauchbar waren;-) ... Datenbank Verzeichnis des SQL Servers dafür vom Dateibackup aus. ...
    (microsoft.public.de.sqlserver)
  • Re: Installing g95 on OS X
    ... I've trashed my Windows boxes several times. ... Unix boxes tend to be harder in that it tends to take sysadmin ... In any case, have backups. ...
    (comp.lang.fortran)
  • Re: Location of Data
    ... first install), then you will probably reach a point on your second or third ... Moving Data Flolder for Windows Small Business Server 2003 ... >> As far as SQL backups, use SQL Enterprise manager to do at least daily>> backups to your D drive and then let your Backup program bakup the SQL ...
    (microsoft.public.windows.server.sbs)