• shrinking operation disregards indexing..which degrades the performance. What calls for you to shrink the database.

    If its only the log file that has grown too big then try thi

    use UrDbName

    Backup Log UrDbName WITH TRUNCATE_ONLY

    DBCC SHRINKFILE (logical name of Log File)

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."