Create Publish InfoPath forms by a4050342


									SQL Saturday #8 – SharePoint Scene

Asst Director, Web Services
Orange County Public Schools
   User’s Guide to the Apple ][ - 1983
   FoxPro 2 Programming Guide – 1992
   Debugging and Maintaining FoxPro – 1992
   Using Visual FoxPro 3.0 – 1995
   Using Visual FoxPro 5.0 – 1996
   Office and SharePoint User’s Guide - 2008

     10/25/2008   Michael P. Antonovich         2
   Content Recovery
     Recycle Bin and Versioning
   Site Recovery
     Recover from accidental deletion/data recovery to the
      same hardware
   Disaster Recovery
     Recovery / migration to new hardware

     10/25/2008   Michael P. Antonovich                       3
   SharePoint has a 2-stage Recycle Bin
   Managed from Central Administration Console
   First stage displays deleted items for logged in
   Second stage displays items deleted from 1st
    stage recycle bin by user
   Max retention set by Central Administrator and
    defaults to 30 days for both.
     10/25/2008   Michael P. Antonovich                4
10/25/2008   Michael P. Antonovich   5
   Versioning lets you track major and minor
    versions/releases of a document/list item.
   Major versions represent published versions.
   Minor versions represent drafts.
   You can control the number of versions retained.
   Versioning lets you recover accidental changes.

     10/25/2008   Michael P. Antonovich                6
10/25/2008   Michael P. Antonovich   7
   SharePoint maintains several DBs including:
        Content Databases
        Configuration & Administration Databases
        Search Databases
        Reporting Server Database and a separate TempDB
        SharePoint AdminContent Database
        Single Sign-on Database
   Other Objects include:
     Web Applications
     Shared services
     Global Search settings

        10/25/2008   Michael P. Antonovich                 8
   Content
   Customizations
   Configurations (SharePoint Server)
   Binary Files (SharePoint Server)
   Configurations (IIS)
   Binary Files (Operating System)

     10/25/2008   Michael P. Antonovich   9
   Recommendation:
    Reinstall the operating system, SQL Server, and
    Office SharePoint Server from the installation

   If you do want to backup binaries, a standard file-
    system backup on a regular basis will suffice.

     10/25/2008   Michael P. Antonovich               10
   The IIS metabase is easily corrupted or
    overwritten. It includes:
        Application Pool Settings
        HTTP Compression Settings
                                             As these can be found on
        Time-out Settings                   the Web Servers, an image
        Custom ISAPI filters                backup of at least one of
        Network Load Balancing Settings     your web servers should
        Host Header Entries                 capture this information.
        Secure Socket Layer Certificates
        Dedicated IP Address Settings

        10/25/2008   Michael P. Antonovich                               11
   Easiest way is to make a full image of one of your
    web front-ends. If you have more than one, you
    probably can do any one because they are
    probably all similar.

     10/25/2008   Michael P. Antonovich              12
   You cannot restore from a backup of the Central
    Administration content database and
    configuration database unless you create these
    backups from a fully stopped farm.
   Document all Central Administration
    configuration settings and customizations.
   Consider using redundancy such as clustering or
     10/25/2008   Michael P. Antonovich               13
   Recommendation:
    Package all customizations as solutions and
    backup the solution files.

   Solutions can contain:
          Web Parts
          Security policy changes

     10/25/2008      Michael P. Antonovich        14
   Backup the 12 Hive which contains all your template
   Backup Inetpub (location of IIS virtual directories)
   C:\WINNT\ASSEMBLY (location of Global Assembly
    Cache (GAC). Holds .NET Framework code

(Again an image backup of a web server might suffice.)

     10/25/2008   Michael P. Antonovich                    15
   Backup all content using one of the following:
        Office SharePoint Server’s built-in tools
        SharePoint Designer
        SQL Server
        Microsoft System Center Data Protection Manager
   If you backup your Search database with SQL
    Server, you will need to re-create the index when
    you restore the database
        10/25/2008   Michael P. Antonovich                 16
   There are several ways to fine-tune the backup of
    your content database.
        Central Administration Backup
        STSADM.EXE
        SharePoint Developer
        3rd Party Tools

        10/25/2008   Michael P. Antonovich          17
10/25/2008   Michael P. Antonovich   18
   You can to backup the following components
     The entire server farm including the configuration db
      which includes the web applications and CA
     All Windows SharePoint Web Application
     Individual SharePoint Web Applications
     Individual Content Databases
     Individual SSPs
     SharePoint Search (Search application and db)

     10/25/2008   Michael P. Antonovich                       19
   Does not provide scheduling functionality.
   Does not automatically delete old backup files.
   Cannot backup directly to tape.
   Cannot restore configuration files
   Does not backup custom solution files
   Does not backup customizations or IIS settings
   No granular recovery ability
   No backup of web front-ends
   Backup & Restore operations are process-intensive
     10/25/2008   Michael P. Antonovich                 20
10/25/2008   Michael P. Antonovich   21
   Open a Command window and type STSADM
    from any directory
     (you must first add the STSADM directory to your
      search path so you can execute it from any directory)

   STSADM –HELP gives you the command syntax
     Most syntax is: STSADM –o <operation> <parameters>

     10/25/2008   Michael P. Antonovich                       22
   Can be scheduled with Windows Task Scheduler
   Provides restorable backups of Search
   Can create backups at farm, web application, or
    site-collection level

     10/25/2008   Michael P. Antonovich               23
   Cannot back up directly to tape
   Does not provide automatic deletion of old backup
   Cannot restore CA content or configuration
   Does not backup custom solutions, Inetpub, the 12
    hive, SSL certificates
   Should not be used on sites > 12 to 15 GB or content
    databases > 100 GB
     10/25/2008   Michael P. Antonovich                    24
To create the list:
 STSADM –o enumsites –url http://<<server>>/

To view the list:
 TYPE allsites.txt

   10/25/2008   Michael P. Antonovich           25
   Site Collection Backup:
      STSADM –o backup
       - URL http://<<server>>/site/<<sitename>>
       - filename C:/backup/<<sitename>>.bak
   Catastrophic Backup
       STSADM –o backup
         - directory <<UNC path or local drive>>
         - backupmethod <full or differential>
      Can also be used for individual DBs or web apps by using
      the –item parameter

     10/25/2008   Michael P. Antonovich                          26
   To get help on the backup history command:
        STSADM –help backuphistory
        Only used with Catastrophic backup

   To view backup history for a server:
        STSADM –o backuphistory –directory

Warning: Don’t use STSADM for site collections >15 GB

     10/25/2008   Michael P. Antonovich             27
10/25/2008   Michael P. Antonovich   28
   With all of the SQL Server databases SharePoint creates,
    you might think that the answer to your disaster
    recovery scenario is to simply backup each of these
    databases on a regular basis. Right?

   It is often the better choice for large content databases,
    but remember that data can be distributed across:
        Front-end Web Servers
        Back-end Database Servers
        Application Servers
        Indexing servers

        10/25/2008   Michael P. Antonovich                       29
   A big problem with SQL Server backups is that a
    restore is all or nothing.
     For example, to fix a problem where someone
      accidentally deletes a site, you would have to restore
      the entire content database that held that site. That
      could affect dozens if not hundreds of other sites.

     10/25/2008   Michael P. Antonovich                        30
   SharePoint Designer is a separate Microsoft
    Product that allows you to reconfigure
    SharePoint. It also provides backup and restore
   Steps:
     Open Site within SharePoint Designer
     Select: Site  Administration  Backup Web Site
     Creates a .cmp file which can be restored using:
      Site  Administrators  Restore Web Site

     10/25/2008   Michael P. Antonovich                  31
   Leverages existing SQL Server disaster recovery
   Full and differential backups can be made
   Provides full-fidelity data backup
   Can be faster than SharePoint Server backups

     10/25/2008   Michael P. Antonovich               32
   Does not include front-end Web server custom
   Can backup Central Administration content and
    configuration databases, but restore is not
   Does not backup IIS settings made outside of
    SharePoint (host headers, dedicated IP
    addresses and SSL certificates)
     10/25/2008   Michael P. Antonovich             33
   From the File Menu, you can also export a site as:
     Personal Web Package
     SharePoint Site Template (.stp)

     10/25/2008   Michael P. Antonovich              34
10/25/2008   Michael P. Antonovich   35
10/25/2008   Michael P. Antonovich   36
   Some common 3rd party tools for SharePoint
    backup and recovery include:

        AvePoint – DocAve
        Idera – Point Admin
        EMC2 – Backup Manager
        Webfox – Backup Elite

    Just to name a few
        10/25/2008   Michael P. Antonovich       37

     10/25/2008   Michael P. Antonovich           38
10/25/2008   Michael P. Antonovich   39
        Don’t forget to fill out your evaluations.

Michael P. Antonovich
SharePoint Book Blog Site:

To top