Re: Sqlmaint.exe problem

You can script that yourself as well. It is pretty easy. But do you really
want to automatically repair errors without first determining what they were
and what is causing them?

--
Andrew J. Kelly SQL MVP


"Olav" <Olav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BCA6BBE3-DEF0-4370-9886-B5F2EC4BE50F@xxxxxxxxxxxxxxxx
> 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: Sqlmaint.exe problem
    ... You can use sp_dboption to place the db in single user mode ... > Well Andrew, I am listening... ... >> want to automatically repair errors without first determining what they ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • 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
    ... To have DBCC CHECKDB to repair error it seems to me that the SQL Server must ... > Andrew J. Kelly SQL MVP ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
Loading