Re: Sqlmaint.exe problem

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: Transferring hard disks with XP to new PC
    ... Not a waste of time on the repair, it worked and kept most of the config, ... "Andrew E." ... > Youre wasting youre time on a "repair" of xp. ... >> Windows saw IDE as IDE and made no other requests to the system to fine tune, ...
    (microsoft.public.windowsxp.hardware)
  • Re: Chaning Hardare chipsets wiht XP home
    ... The breadth of your knowledge never ceases to amaze me. ... Andrew E. wrote: ... display screen is with a new installation,format,then install.A repair is a waste ...
    (microsoft.public.windowsxp.basics)
  • Re: Windows XP Pro and a Motherboard replacement from a hardware failu
    ... Andrew E. wrote: ... no possible way to "repair" the OS already on the hd,a clean install is a ... On-Line Help Computer Service ... Syberfix Remote Computer Repair ...
    (microsoft.public.windowsxp.accessibility)
  • RE: Boot failure -- need help
    ... No, no, no, and no. Useless as usual, Andrew. ... repair was finished. ... Sometimes when I turn the system on, it immediately loads the BIOS ... will explain why multiposting is A Bad Thing and will get you *less* ...
    (microsoft.public.windowsxp.hardware)
  • Re: Sad update on P61310JX4 blanking out problem.
    ... If you repair these things for others, ... When anyone asks for a recommendation about a new set find another ... Customers follows many different ... TV that does it's stuff and one button remote. ...
    (sci.electronics.repair)