Post reply

Database MDF File Size Issue

  • July 11, 2012 at 12:35 am

    #272309

    Hi,

    I have a Database which size is 80 GB, and It has duplicate table for all tables. So I dropped these necessary tables by using Drop Table query but my database file size is still 80 GB but now its size should be 40 GB, So can any one tell me why the size of database doesn't reduced and how can I do so.

  • July 11, 2012 at 12:38 am

    #1511345

    In SQL Server Management Studio, Right Click the database | Tasks | Shrink | Files

    Choose the Appropriate file and options.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • July 11, 2012 at 12:42 am

    #1511346

    will you please explain it

  • July 11, 2012 at 12:45 am

    #1511349

    You can use DBCC SHRINKFILE

    For more details please visit

    http://msdn.microsoft.com/en-us/library/ms189493.aspx

  • July 11, 2012 at 12:46 am

    #1511350

    The options are described on TechNet

    If there are anything particular that seem unclear too you, please tell.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • July 11, 2012 at 1:00 am

    #1511354

    amitsingh308 (7/11/2012)

    will you please explain it

    When you drop objects from the database the files do not automatically reduce in physical size

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 11, 2012 at 3:31 am

    #1511411

    Hi Amit,

    Simple way to understanding when you drop a table, table will gone but the space will not reduce of physical database, so please shrink it. Shrink like a fragmentation task.

  • July 11, 2012 at 3:38 am

    #1511414

    Thanx to every on Problem has been resolve by database file srinking.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply