Virtual Learning Platforms Thread, SharePoint Database size in Technical; Just wondering how big the sql database of your sharePoint deployments are.
We started of with a 10gb LUN on ...
26th July 2008, 03:29 PM #1
SharePoint Database size
Just wondering how big the sql database of your sharePoint deployments are.
We started of with a 10gb LUN on our SAN for this
2 weeks ago doubled it to 20gb now it only 20mb free again. Unfortunately when we did the SAN setup we did not have intention of using any additional SQL space than SIMS,AV and print management.(how wrong can you be).
Now big problem is no more space available on that LUN so thinking about starting again and allowing a lot more space. Thinking of allowing 200gb on a new one.
26th July 2008, 03:52 PM #2
Mine's currently about 18GB and had initially allowed for about 140GB disk capacity, assuming another 140GB for the database to be dumped to disk on a daily basis, which is then backed up to tape overnight.
27th July 2008, 01:19 AM #3
200GB is a good size - you wont fill that up very quickly if your only going to run SharePoint.
Keep an eye on your log database size and make sure it gets reduced in size after a full backup.
Make sure you have a read up on best practise for SQL Server and SharePoint as this will give you some good tips on performance - for example... Tell you database to increase at 100MB instead of 10MB as this will help upload file performance.
29th July 2008, 11:11 AM #4
Have you checked the SQL logs they will need shrinking.
Another issue is video.
29th July 2008, 02:02 PM #5
shrinking your database should be part of your full back up of you sql server databases.
By imiddleton25 in forum Virtual Learning Platforms
Last Post: 25th June 2008, 12:06 AM
By Simcfc73 in forum Windows
Last Post: 3rd March 2008, 04:51 PM
By Grommit in forum MIS Systems
Last Post: 27th September 2007, 07:55 AM
By sidewinder in forum Windows
Last Post: 28th February 2007, 10:37 AM
By plexer in forum Windows
Last Post: 12th December 2006, 10:08 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)