Tag Info

Hot answers tagged

5

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 ...


4

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: ...


3

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 ...


2

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 ...


1

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


1

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 ...


1

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.



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