Results 1 to 15 of 16

Thread: DBCC ShrinkDatabase(ABC, 10) ..... finished with no actual response....

Hybrid View

  1. 11-08-2007, 03:06 PM #1
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    No, they are different. Moving page option moves pages in same file to front, kind of compact. That leaves free sapce in rear of the file for shrinking.
    Reply With Quote Reply With Quote
  2. 11-09-2007, 11:41 AM #2
    DLu
    DLu is offline Registered User
    Join Date
    Mar 2003
    Posts
    383
    Hi Ramio:

    DBCC SHRINKFILE
    ( { file_name | file_id }
    { [ , target_size ]
    | [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ] })

    don't see the option you mentioned here...
    Could you give more detail about EM option on moving pages?
    thanks
    -D
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules