Re: Sqlmaint.exe problem

It runs, but dont do anything.

I want sqlmaint to check for db errors and repair.

To have DBCC CHECKDB to repair error it seems to me that the SQL Server must
be started in single-user mode. I want this to be as simple as possible for
the user.

"Andrew J. Kelly" wrote:

> Do you mean it runs and doesn't do anything or simply doesn't run?
> Personally I would just forget about sql_maint and create your own job to do
> the check. If you are talking about integrity checks then just create a job
> that runs
>
> DBCC CHECKDB
> DBCC CHECKCATALOG
>
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Olav" <Olav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:BA6F6483-B0BA-48A6-9E1F-34B3F7EDD954@xxxxxxxxxxxxxxxx
> > It does not give any messages no matter what switches we use. Even no
> > response back when we use the -? switch.
> >
> > "Andrew J. Kelly" wrote:
> >
> >> That's not much to go on. Can you be more specific than "it will not run
> >> properly"?
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "Olav" <Olav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:F0328CFA-59C7-4546-8099-57B671E7425E@xxxxxxxxxxxxxxxx
> >> > Hi we have an database check routine based on sqlmaint. This works fine
> >> > on
> >> > most machines but on my customers Windows 2000 machine i will not run
> >> > properly. It will not even show the switches using sqlmaint -?
> >> > Any idea?
> >> > Regards,
> >> > Olav
> >> >
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Face 8909 error
    ... Try running a DBCC CHECKDB for that DB and see what it says your options are. ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ...
    (microsoft.public.sqlserver.setup)
  • Re: Sqlmaint.exe problem
    ... want to automatically repair errors without first determining what they were ... > To have DBCC CHECKDB to repair error it seems to me that the SQL Server ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: DBCC CheckDB
    ... I agree with Andrew. ... I recommend you to run the DBCC CHECKDB atleast once a ... The idea behind a DBCC CHECKDB ... > to ensure physical integrity of your database objects. ...
    (microsoft.public.sqlserver.server)
  • Re: Checking and Indexing
    ... Any maintenance activity such as DBCC CHECKDB and DBREINDEX will have some ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
Loading