Re: Enterprise Manager Newbie Question

Yes. SQLCMD does not require SSMS. SSMS has a mode to help author such
scripts, but they can be run without the full toolkit. Again, BOL (Books
On-Line) has the details.

As for the file shares, only the SQL Service account needs access to the
share for the backup file. It already controls the folders for the database
and logs. BTW, a SQL backup is not a simple copy of the database files. It
is a bit more complex so a backup can be transactionally consistent AND not
cause blocking while taking the backup. Suffice it to say that the SQL
Server handles all the heavy lifting, all you need to do is tell it to start
and where to find/place the file.

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



"BayCoMIS" <BayCoMIS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3DCE1CE9-524E-4610-A60D-999E080A7CA0@xxxxxxxxxxxxxxxx
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)
  • 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)
  • 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)