The need for speed. SharePoint Optimisation and recovery from a database perspective. By Tom Bizannes Microsoft Certified Professional MacroView Business Technology Level 12, 171 Clarence St, Sydney, Australia +612 9249 2700. Tom Bizannes. A Database Guy caught in
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
SharePoint Optimisation and recovery from a database perspective
By Tom Bizannes
Microsoft Certified Professional
MacroView Business Technology
Level 12, 171 Clarence St, Sydney, Australia
+612 9249 2700
A Database Guy caught in
the Land of theLost SharePoint
Working with the leading
Document Management Software
for SharePoint (WISDOM)
For restoring from failure or corruption
For item level restore
When you back up by using the Stsadm command-line tool, you can back up individual aspects of your SharePoint Products and Technologies deployment. For example, you can back up an individual site collection or you can back up the entire farm.
To export sites from your SharePoint Products and Technologies deployment, you use the following Stsadm command.
The SharePoint administrator needs to work together with
The Microsoft Sql Server administrator
and the Windows Network administrator
Someone suggested 300G is the new 100G limit
The limit all depends on your infrastructure
Go into Control Panel and show the version field
SELECT [VersionId] ,[Version] ,[Id] ,[UserName] ,[TimeStamp] ,[FinalizeTimeStamp] ,[Mode] ,[ModeStack] ,[Updates] ,[Notes] FROM [SharePoint_Config].[dbo].[Versions] WHERE VersionId = \'00000000-0000-0000-0000-000000000000\' ORDER BY Id DESC
Using SharePoint Central Administration Web site SharePoint HTML Site Settings admin pages or IIS Manager, on the web sites properties HTTP Headers tab, virtual servers once extended will show the following version numbers:
Service Pack 2 - 184.108.40.20621
MOSS 20071 or WSS 3.0 Cumulative update (KB956056 & KB956057) 220.127.116.1127MOSS 20071 or WSS 3.0 Infrastructure Update (KB951695 & KB951297) 18.104.22.16818MOSS 20071 or WSS 3.0 SP1 22.214.171.12419 MOSS 20071 or WSS 3.0 RTM 126.96.36.19918
Q: Where do you set a default fill factor?
Best practices for the front end include:
Best practices for the back end include: