Re: DBCC Checkdb,

Tech-Archive recommends: Fix windows errors by optimizing your registry

Frank Cherjak wrote:
sorry für die vielen Newbee Fragen: (PS an Tanja: Mail Problem ist
jetzt behoben - war nicht fertig eingerichtet)


Fehler beim Maintenance Plan mit dem ich leider nichts anfangen kann.

ich habe zur leichteren Fehlerfindung alle weiteren Step disabled - es
bleibt nur der erste Step Check Databases über. Anbei die Job History.
Leider schneidet der SQL Teile vom Text ab

Hallo Frank,
zum einem solltest Du lieber das Protokoll im Plan aktivieren und das dann anschauen, zum anderen hast Du vielleicht auch schon gemerkt, dass im Errorlog immer die gleichen Datenbanken auftauchen. It's not a feature, it's a bug!

http://support.microsoft.com/kb/934458/en-us
FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053

Einen schönen Tag noch,
Christoph
--
(Please post ALL replies to the newsgroup only unless indicated
otherwise)

.

Relevant Pages

  • Re: Maintenance Plan Caused System To Hang
    ... ran DBCC CHECKDB) I was connected to the server through Terminal Services. ... Even though the server has 2 GB of RAM and is used exclusively for SQL 2005, ... maintenance plan in SQL 2005 and ran it. ... Back up the database and transaction log ...
    (comp.databases.ms-sqlserver)
  • Strategy for a databse
    ... I have some experience with building a database of people, ... regular trips but often also charters of various lenghts. ... I need to plan ... For all these things, and many others I have reports, in Excel format, ...
    (microsoft.public.access.gettingstarted)
  • Re: Wiki software for genealogy (long)
    ... "When we've ironed out the bugs, this will be the one everyone wants" hands-down over any given 5-year plan of business. ... You can kludge most of 'em into doing the other, and you can even browbeat 'em into doing a migration database, but they won't do 'em as well as a dedicated program will. ... Which is why a first requirement should be for a package, not a single program, to be built around a database for which a decent toolset is available - at the very least for reporting. ... If the data is accessible in that way and the data model is well designed in the first place a whole set of programs can be built round it, either by the vendor or by sufficiently skilled users. ...
    (soc.genealogy.britain)
  • Re: network permissions for Btrieve (PSQL 8.x) files
    ... should read the manual carefully (plan to have an hour of quiet time to ... database, but once implemented, you can lock out all user access from ... still use the database from both Btrieve and SQL/ODBC. ... > files for the usual client-users, ...
    (comp.databases.btrieve)