Re: Sqlmaint.exe problem

Well I really don't know why it isn't running. Maybe you need to reinstall
the DLL's but I honestly don't know. That's one of the reasons why I don't
like using the MP. When you have an issue it can be very hard to figure out
what the real problem is. As for the checkdb you would have to put the DB
in single user mode and then run it specifying REPAIR_FAST or
REPAIR_REBUILD. You can use sp_dboption to place the db in single user mode
first. BooksOnLine has all the info and you are only talking about a few
lines of code here.

--
Andrew J. Kelly SQL MVP


"Olav" <Olav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2E50FF2E-F84B-4455-B572-6128A2D2C21D@xxxxxxxxxxxxxxxx
> Well Andrew, I am listening...
> The basic idea is to check and repair automatically with each update we
> are
> sending out to our small customers. These are customers with a single
> workstation or a small network and they have little cumputer knowledge.So
> we
> want as little maintenance as possible.
>
> "Andrew J. Kelly" wrote:
>
>> 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
    ... 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: Prohibit User Logons
    ... Place the database in single user mode. ... Andrew J. Kelly SQL MVP ... "Ray Price" wrote in message ...
    (microsoft.public.sqlserver.setup)