Home Forums SQL Server 7,2000 Administration Take too long to shrink a huge database, HELP!!!! RE: Take too long to shrink a huge database, HELP!!!!

  • January 25, 2004 at 4:22 pm

    #491545

    I know that it seems drastic I would try (on a test database first)

    1. Backup the database (just in case)

    2. Detach the database

    3. (I usually delete the log file)

    4. reattach the database (since its new it will have your default size allocation)