Results 1 to 2 of 2

Thread: Shrinking Files

  1. 11-03-2006, 10:25 AM #1
    bobkand
    bobkand is offline Registered User
    Join Date
    Sep 2005
    Posts
    43

    Question Shrinking Files

    What is the best way to Shrink a Data file and Log Files.
    Reply With Quote Reply With Quote
  2. 11-03-2006, 11:29 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    dbcc shrinkdatabase

    or use enterprise manager (if the database is small).

    It is very time consuming operation so do it during off hours.
    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