Results 1 to 3 of 3

Thread: MSSQL 2K - DB Maintenance Plan - Question

  1. 05-09-2006, 12:09 PM #1
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    MSSQL 2K - DB Maintenance Plan - Question

    Can anyone tell me what the DBCC command is for the Database Optimization - Reorganize data and Indes pages? Said job is failing and I'm trying to get more information that "step 1 failed". I want to run the process from QA for analysis.
    Reply With Quote Reply With Quote
  2. 05-09-2006, 02:59 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    The actual TSQL command is DBCC dbreindex ... but SQL optimization job uses SQLMaint.exe with the flag -RebldIdx
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 05-09-2006, 03:05 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You should check plan's log file for detailed reason of failure.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules