Tag Info

Hot answers tagged


First thing you should do is choose the appropriate recovery model for your databases. If you need point in time restore, go for the FULL recovery model. The price you have to pay is to make regular log backups or your logfile will grow indefinitely. Taking a full backup does not stop them from growing. If you use mirroring or log shipping, you also need to ...


You should be backing up and truncating your TLOGS. If you have not been doing that, than yes, do a backup, truncate, and shrink will restore space. To keep that space however, you will need to set growth limits on your database and log files. Microsoft has a paper on "best practices" with SQL maintenance: ...


Personally, If you are not strapped for space, I would both back up content and configuration as well as using your regular backups. Technically, you do not need to back up the content as well as have a backup of the sql instance, however they are really two different types of backups. One allows you to restore the site as a whole with everything on it to ...


This really depends on your level of access to SharePoint as well as to the server that your SharePoint installation is running on. If you have Site Collection Administration privileges you can go to Site Settings | Site Collection Administration | Storage Metrics to find out how much disk space is being occupied by the site. Though this doesn't give you a ...


This one is expected behavior. When performing the upgrade, you need to plan on having plenty of drive space available on both System drive as well as Data drive and Log Drive for SQL. Here is some real time example. Once I moved the database to a terrabyte partition, the error was resolved. I found that, in order to reliably upgrade a SharePoint 2007 ...


It specifically deals with the growth rate of your data and the space you expect it to use. This link explains the overall purpose of storage space and growth


If you are using MOSS, Have a look at: http://spdocgen.codeplex.com/ Gives you more information than you need but definitely should do for the space. Has also been compiled to work with 2010; available here: http://blog.lekman.com/2010/05/automating-sharepoint-deployments.html


My first port of call would be SQL Server Management Studio. This is available even with the Express version (download the "with tools" edition, or download SSMS as separate package). Is 16GB a reasonable size for your database? It is quite easy to set up a database with a FULL recovery model and no log backup schedule, which can result in huge database ...


As an Site Owner (and not a Site Collection Admin) you should be able to connect to your site using SharePoint Designer. Once connected, you can click on Site->Reports->Site Summary. This report shows All Files and the total size in KB of all files on your site.


Is the information reported using SharePoint Designer (2007) sufficient? I have been using the properties reported by right clicking on the site, in the folder list, in SharePoint Designer. This gives a report of how many files are in the system and how much space is used.


Frankly I wonder if you're going above and beyond the call of duty trying to find how much space your site is using :) This is something Operations should be able to tell you! It is definitely true that SharePoint doesn't make this easy (to my knowledge), but tools such as Quest are typically used for this kind of reporting.


This might not be what you want, but have you at all considered just setting site quotas to secure sites staying under a predefined size? http://technet.microsoft.com/en-us/library/cc287673.aspx

Only top voted, non community-wiki answers of a minimum length are eligible