Re: Restore points available

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 17:11:04 -0500

You might want to brush up on the training or polish the resume. DBA
without training is a complicated way of saying 'scapegoat'.

FYI, sp_delete_backuphistory runs very slowly. If you kill it in the
middle, it is OK. Find the oldest entry and let it chew a few days off at a
time. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:%23EqOwf%23%23DHA.1464@tk2msftngp13.phx.gbl...
>
> "Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
> news:uFyWM%239%23DHA.624@TK2MSFTNGP11.phx.gbl...
>
> >
> > Second, there is a sp_delete_backuphistory procedure to clean out old
> unused
> > backup jobs so you can keep the size of the backup list down to a
> managable
> > level.
>
> My execution of this SP has been running for over seven minutes.  I get
> nervous when I have to do anything that I don't know about like this.
> Whoever had the brilliant idea of tacking DBA onto my job title should be
> fired.  For some reason, "knowing some things about Access" apparently
> qualified me to be a SQL Server DBA, in the eyes of others.  As far as I'm
> concerned, what this really adds to my title is "fraud."  I'm just
thinking
> out loud for the sake of distracting myself.  Ignore this post.
>
> -- 
>
> Ray at work
> Microsoft ASP MVP
>
>
>

Relevant Pages

  • Re: sql transactions per second
    ... good sense of app server and web server hit counts and capacity needs, ... SQL Server to the max, and what their SQL transaction per second count is. ... before all other hardware constrains growth). ... Be prepared to hire a really good DBA who knows how ...
    (microsoft.public.sqlserver.server)
  • Re: Among available RDBMS. When to use ...
    ... "When these new options are not set, SQL Server 2005 default database ... Given that Oracle's multiversioning has long outperformed SQL Server, ... is it possible to keep DBA? ... I would think an ISV needs a DBA more, ...
    (comp.databases)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... now the SQL injection attacks and/or crash the service attacks need ... to be address separately (no real DBA options here). ... The proper way to secure this though isn't in SQL Server per se. ... Microsoft's putting a lot of effort into security. ...
    (microsoft.public.sqlserver.security)
  • Re: DBA Access to SQL Server
    ... > look at the qualifications or trust of your sql dba ... > rather than his/her permissions. ... > 99.9% of the time i hear this question it's a control ... if your support model includes the DBA folks doing the SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: restrict access to a database
    ... Since the SQL SERVER machine is in the clients place and DBA needs to ... OS Level admin password and SA password for sql server and do not hand it to ... we've got a product which has SQL Server as the backend database. ...
    (microsoft.public.sqlserver.security)