Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Take too long to shrink a huge database, HELP!!!!

    USe the script below to srink the log file and then modify it to srink the db file

    use Your_Database

    dbcc shrinkfile (2,2)

    checkpoint

    backup log Your_Database with truncate_only

    checkpoint

    dbcc shrinkfile (2,2)

    checkpoint

    go

    use master

    go

    sp_helpdb

    go

Viewing post 1 (of 1 total)