Re: db maintanence plan failure

From: Param R. (pr_at_nospam.com)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 11:04:28 -0600

I agree I need to know what is causing the problem. But how can I find that
out? The database seems to appear functional from the application
perspective. How can I determine if it is corrupt and if so what is causing
it to be corrupt? The link below gives me some info, but not all.

thanks!

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:e20IkmqEFHA.1264@TK2MSFTNGP12.phx.gbl...
> If my car keep breaking down, I'd like to know why that happen so I can
> avoid it keeping breaking down when I travel at high speed. I.e., if you
> get such problem, you want to do root-cause analysis why they happen.
> Often it is because hardware problems.
>
> In other words, the option in maint wiz is IMO not well thought through,
> and AFAIK, it will be removed in next version of SQL Server. The option,
> btw makes maint wiz execute DBCC CHECKDB using the REPAIR_FAST option.
>
> To be able to run DBCC CHECKDB with FAST_REPAIR, the database must be in
> single user mode, so if you have users in the database, the command and
> subsequently job will fail.
>
> Also, you might want to check out:
> http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Param R." <pr@nospam.com> wrote in message
> news:%23Czx7SqEFHA.1188@tk2msftngp13.phx.gbl...
>> OK. But wouldnt I want it to fix any problems? What is the best way then?
>>
>> thanks!
>>
>> "Uri Dimant" <urid@iscar.co.il> wrote in message
>> news:eSii%23klEFHA.2032@tk2msftngp13.phx.gbl...
>>> Param
>>> Under Tab 'Integrity' uncheck 'Attempt to repair any minor problems'
>>> SQL Server is trying to repair some problems but it requires database
>>> to be
>>> in single user mode.
>>>
>>>
>>>
>>> "Param R." <pr@nospam.com> wrote in message
>>> news:ed%23BifjEFHA.1012@TK2MSFTNGP14.phx.gbl...
>>>> Hi all!
>>>>
>>>> I have a DB Maintanence plan configured to run once a week that is
>>> supposed
>>>> to perform optimizations and integrity checks on all user databases.
>>>> This
>>> is
>>>> split into 2 seperate jobs when I look at the Jobs node under SQL
>>>> Agent.
>>> The
>>>> optimizations is set to run at 4 am & the integrity at 5 am. It appears
>>> that
>>>> the integrity check job keeps failing. The log says something about
>>>> 'mosesdb' needs to be in single user mode. Any ideas? The optimization
>>> jobs
>>>> seems to complete OK
>>>>
>>>> TIA!
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Relevant Pages

  • Re: A Sql Compact problem
    ... causing this problem. ... database has an SupplierArticles table. ... SupplierArticleNo defined as nvarchar. ... You're probably right about SSCE not being a managed app, ...
    (microsoft.public.sqlserver.ce)
  • Re: Index Errors!
    ... the NT event logs and run all relevant hardware diagnostics on ... > on another table or database. ... >>> What could be causing these errors to appear so ... >>execute DBCC CHECKDB to determine the extent of the ...
    (microsoft.public.sqlserver.server)
  • Re: CursorAdapter, MySQL - View definition has been changed.
    ... I can fix the fixed length fields by casting the static text to a fixed ... In my MySQL database the Comment ... I am not sure what is causing this error. ... this error message? ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Help IE6 not navigating away from homepage
    ... My current theory, and it's only a theory, is that an anti-virus is causing the problem by deleting messages as they are saved to the hard drive even though email scanning is turned off. ... Try repairing the database with WMUtil from www.oehelp.com ... messages should be lost, some may be downloaded again and you may lose some ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • RE: Invalid authorization specification (SQL-28000)
    ... I don't know what is causing the following error, ... Logging into the same database with the same user id and password. ... This E-mail message is for the sole use of the intended recipientand ...
    (perl.dbi.users)
Loading