• Are you asking how to shink the database and not the log? You'd do it by shrinking each of the data files individually.

    Note Steve's warning above. You don't want to shrink the database down, unless there's a good reason. See this link[/url], and also check out the two links at the bottom of that article

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass