Options

Database size maintenance

surajvsurajv Member Posts: 32
Is there database maintenance that we should be doing to manage the growth of the database size? I am thinking about transaction logs and other SQL Server database files that tend to grow over time. I would like to make sure that we are managing the growth first, before adding disk space.

Is there any best practice for archiving?

Comments

  • Options
    Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    I would encourage you to do some searching on this website and MSDN.

    Your databases has two pieces. The actual database and the transaction log.

    They grow in different ways and have their own way of being maintained, depending on your wishes for recovery whenever things go wrong.
Sign In or Register to comment.