Re: Enterprise Manager Newbie Question

First, Enterprise Manager does not work with SQL 2005. You have to use the
new SQL Server Management Studio. SSMS does work with SQL 2000 and SQL
2005.

Second, why don't you write a short backup script using the SQLCMD utility
that he can invoke to create a backup, you do not have to start a backup
using a GUI. Alternatively, with transaction log backups and FULL recovery,
he can recover to any point in time with the scheduled full restore as the
starting point. Therefore he has no need to create random backups.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"BayCoMIS" <BayCoMIS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:80DC3B08-92DF-46C5-A697-9566F5159404@xxxxxxxxxxxxxxxx
Let me preface by saying that I'm not a DBA-type person. I'm more of the
network guy who truly hopes to have an honest-to-God DBA hired on within
the
next six months. I'm the interim DBA without much DBA knowledge just
backing
up databases as best I can.

For pure political reasons, I must allow a non-IT person access to
Enterprise Manager for a SQL 2005 database within their subnet. (Scary,
to
say the least.) The main reason is that they want to be able to backup
their
own database whenever they see fit -- scheduling be damned! The software
vendor does not offer a backup within their own software; Enterprise
Manager
must be used -- with full admin privileges of the SQL Server!!!

I want to be able to prevent the user from accessing any of the other SQL
databases (2000 & 2005) within the domain. Is this possible? If so, how?
Can someone point me in the right direction?

I'd much prefer a script of some kind to allow the user to run a SQL
backup
of the database without invoking Enterprise Manager at all. Is THIS
possible?

My sanity begs for help. Thanks in advance to whomever can offer
assistance
with this issue.


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
  • Re: Does NTBackup backup SQL Express?
    ... schedule backups of the SQL databases which were written to a backup ... models you would have to backup and flush things manually. ... if you load the backup set does the database appear to be ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)
  • Re: Does NTBackup backup SQL Express?
    ... as I know enough that the logs must be flushed during every full backup. ... and the SBS server I regularly use runs MySQL not SQL ... if you load the backup set does the database appear to be listed ... I've always scripted my SQL Server backups separatly. ...
    (microsoft.public.windows.server.sbs)
  • Re: URGENT: SQL 6.5 Server Crash
    ... > Are these database backup done by SQL Server? ... > Or file backups performed by some Windows backup software? ... were they performed while SQL Server was running? ...
    (microsoft.public.sqlserver.server)