locked
Sharepoint 2010 eating space quickly RRS feed

  • Question

  • Our Database server that is hosting our Sharepoint 2010 environment is consuming space quick and fast. Not sure how we can ensure or reduce consumption. Please suggest if this is a log file issue for the database server or expected behaviour.

     

     


    RRS
    Monday, January 30, 2012 6:44 PM

Answers

  • You have two options, as Trevor has written.

    Either backup your db regularly (full backup and transaction log backup)

    Or switch your database recovery model to simple and shrink your log file.


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.
    • Marked as answer by srituraj Monday, January 30, 2012 11:34 PM
    Monday, January 30, 2012 7:23 PM
  • By default, the model database in SQL Server has the Recovery Model set to Full.  Unless you've changed the model database's Recovery Model to Simple, all databases created by SharePoint will also have a Recovery Model of Full.

    Unless you're using SQL Mirroring, Log Shipping, or require point-in-time recovery capabilities, change the Recovery Model of your SharePoint databases to Simple (Properties -> Options on the database in the SQL Management Studio).  Then, shrink the Log file (Tasks -> Shrink -> File). 
    http://sharepoint.nauplius.net
    • Marked as answer by srituraj Monday, January 30, 2012 11:34 PM
    Monday, January 30, 2012 6:51 PM

All replies

  • By default, the model database in SQL Server has the Recovery Model set to Full.  Unless you've changed the model database's Recovery Model to Simple, all databases created by SharePoint will also have a Recovery Model of Full.

    Unless you're using SQL Mirroring, Log Shipping, or require point-in-time recovery capabilities, change the Recovery Model of your SharePoint databases to Simple (Properties -> Options on the database in the SQL Management Studio).  Then, shrink the Log file (Tasks -> Shrink -> File). 
    http://sharepoint.nauplius.net
    • Marked as answer by srituraj Monday, January 30, 2012 11:34 PM
    Monday, January 30, 2012 6:51 PM
  • You have two options, as Trevor has written.

    Either backup your db regularly (full backup and transaction log backup)

    Or switch your database recovery model to simple and shrink your log file.


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.
    • Marked as answer by srituraj Monday, January 30, 2012 11:34 PM
    Monday, January 30, 2012 7:23 PM
  • Which service applications are installed on the farm? Some serviceaps (web analytics e.g.) can cause large DB's... Which DB is the big one?
    Monday, January 30, 2012 10:37 PM