Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: DBCC SHRINKFILE is not working as expected ??

    Using various commands to shrink a database can be troublesome. Try using the following commands.

    ---------------------------------------------

    ALTER DATABASE <Db name)

    set recovery simple

    DBCC SHRINKDATABASE (db name,5,TRUNCATEONLY)

    ALTER DATABASE

    set recovery full

    ----------------------------------

    This works...

Viewing post 1 (of 2 total)