Yet more questions on backup (and restore) - Roy Chastain

22-Aug-07 02:35:20
I have MOSS 2007 installed in single server farm.
I installed a full copy of SQL 2005 and followed the farm installation steps.  I only have one server and I do not anticipate
having multiple servers in the farm in this century.

I have looked at the WSS Operations manual concerning backup of WSS using STSADM
and the Technical Reference for STSADM -backup
Both entries can be located from the following URL
(http://technet2.microsoft.com/windowsserver/WSS/en/library/dec1c405-b54b-4c1b-976f-3fa6d814cda51033.mspx?mfr=true)

I must say that they are less then clear or complete.

The Operations manual discussing doing Farm Backups, Web Application Backups, Site Collection Backups and Database Backups.

The Technical Reference discussing a Site Collection Backup and a Catastrophic Backup with the difference being a -URL or a -item
switch.

My basic question is, do I have to do each of these (Farm Backups, Web Application Backups, Site Collection Backups and Database
Backups) backups separately or does a Farm Backup backup everything like its name implies.

My further question is about customizations and 3rd party things.  In a previous post "Full backup and restore" in this group
there was discussion of when to install customizations during the restore process.  It also indicated that it might be good to
save all of the 12 subdirectory.

I have installed several of the Microsoft supplied templates.  I have created 2 new site templates (by doing create template from
this site) from sites I created.  Are these customizations?  If so, what do I need to do to save them?  I looked in the
SiteTemplates directory and I see the administrator templates that I installed, but I do not see my 2 new site templates.

As far a the Configuration Database is concerned.  I am assuming that it can be backed up by Stsadm but it is mentioned that it is
difficult to restore, so should it be backed up using SQL backup tools?  If so, what if anything is necessary to ensure the backup
of the sharepoint and SQL data is consistent?

Thanks
-------------------------------------------
Roy Chastain
KMSYS Worldwide, Inc.
http://www.kmsys.com
reply
 

Sharepoint WebPart
promotion
Silverlight    WPF    WCF    WWF    LINQ   
JavaScript    AJAX    ASP.NET    XAML   
C#    VB.NET    VB 6.0    GDI+    IIS    XML   
.NET Generics    Anonymous Methods    Delegate   
Visual Studio .NET    Expression Blend    Virus   
Windows Vista    Windows XP    Windows Update   
Windows 2003 Server    Windows 2008 Server   
SQL Server    Microsoft Excel    Microsoft Word   
SharePoint    BizTalk    Virtual Earth   
.NET Compact Framework    Web Service   

"Everything" RSS / ATOM Feed Parser
How to send and receive messages through message queuing in .Net
How to Read text file as database
SQL Server 2005 Paging Performance Tip
Display code of web page.
Fully Scalable Excel File Importer class for .net using Microsoft Jet driver
Generic Chart Color Manager class that can be used for any charts
Helper class to style the infragistics wingrid
Using Reflection to detemine as Assembly Info in and out.
Helper class to play with Window (Owners and position)
Resolving displayname from the culture using the XmlLanguage and LanguageSpecificStringDictionary class