Reduce Database Size

Posted by: ramnath-fp on 8 September 2017, 2:35 pm EST

  • Posted 8 September 2017, 2:35 pm EST

    <p>Hi,</p><p>I have one database backup size with 1.05 GB(After shrink database).</p><p>main mdf file size is  1.06 GB.</p><p> Any body have idea to delete trace or garbage data or unused space or deleted record log.</p><p> How to reduce size of the backup.</p><p> </p><p>thanks and regards,</p><p>Ram Nath </p><p>MUMBAI(INDIA) <br></p>
  • Replied 8 September 2017, 2:35 pm EST

    <p>Hello,</p><p>Space is not 'reclaimed' automatically. Since expanded a database file is an 
    'expensive' operation, the decision to 'contract' is left to a deliberative 
    approach. You will have to reduce the database and/or file size to fit your needs. For additional information, look in Books Online for
    <br> <br>DBCC Shrinkdatabase
    <br>DBCC ShrinkFile
    <br> <br>DBCC SHRINKFILE shrinks the size of the specified data/log file for the database.
    <br>Syntax:
    <br> <br>DBCC SHRINKFILE
    <br>    ( { file_name | file_id }
    <br>        { [ , target_size ]
    <br>            | [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ]
    <br>        }
    <br>    )
    <br>DBCC SHRINKDATABASE shrinks the size of the data files in the specified database.
    <br>Syntax:
    <br> <br>( database_name [ , target_percent ]
    <br> [ , { NOTRUNCATE | TRUNCATEONLY } ]
    <br> ) 
    <br> <br>You may also look at the following Microsoft link for  more information on how to reduce the database size:<br>http://msdn.microsoft.com/en-us/library/93ha4180(v=vs.80).aspx </p><p>Thanks, <br></p>
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels