Re: Enterprise Manager Newbie Question

Geoff,

Thanks for the scripting advice. Unfortunately, I don't know much about
SQLCMD scripting. So, my next (obvoius) question would be:

Is it possible to write a script that one could run from a workstation and
NOT have SSMS installed on that workstation? Can we Share out the
directories in which the database and transaction logs are located
(READ-ONLY, of course) and have a script run from the workstation so that we
don't have to have SSMS installed for the user?

Thanks again for your help. I've been researching the SQLCMD and trying to
get a grip on it.


"Geoff N. Hiten" wrote:

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: Cannot Open SQL Server Table in Access.ADP File.
    ... I dont think that SQL Server will take 'veiw dependencies' into effect; ... Generate Script Wizard did not work on my original database, ... After fixing some of my tables and a few stored procedures and views, ...
    (microsoft.public.access.adp.sqlserver)
  • 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: 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: 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)
  • RMAN backup strategy on 10g r2 on linux
    ... "Oracle Database 10g Linux Administration" book in order to understand ... how to efficiently backup and restore our instance of the db. ... I wrote a shell script that is called by cron every night. ...
    (comp.databases.oracle.server)
Loading