Re: db maintanence plan failure
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/14/05
- Next message: Tibor Karaszi: "Re: Connecting to another database"
- Previous message: arthur: "Re: Dual Processors Xeon Support"
- In reply to: Param R.: "Re: db maintanence plan failure"
- Next in thread: Param R.: "Re: db maintanence plan failure"
- Reply: Param R.: "Re: db maintanence plan failure"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 14 Feb 2005 16:27:03 +0100
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! >>> >>> >> >> > >
- Next message: Tibor Karaszi: "Re: Connecting to another database"
- Previous message: arthur: "Re: Dual Processors Xeon Support"
- In reply to: Param R.: "Re: db maintanence plan failure"
- Next in thread: Param R.: "Re: db maintanence plan failure"
- Reply: Param R.: "Re: db maintanence plan failure"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
