feedburner

Subscribe

View Venkat Varkala\

STSADMIN : Backup/Restore vs. Import/Export

Labels:

I have been asked by many about the differences between Backup/Restore vs. Import/Export operations, they both really serve very different purpose.


Backup/Restore Import/Export

  1. Can back up top-level websites (Site Collections), an individual database, a Web application, or an entire farm.

  2. There is no Default File Extension for back up files

  3. Supports "Full" and "Differential" back up. If "overwrite" option is selected while restoring it overwrites entire SiteCollection

  4. Supports UNC path to save/restore backup files.

  5. Backup of Site Collection can be tracked by stsadm -o backuphistory operation

  1. Like Smigrate.exe utility in SPS 2003, you can migrate sites, subsites and Site Collection.

  2. Default file Extension (if not mentioned) ".cmp"

  3. Provides "versions" option to control migrate/overwrite files in site

  4. Backup files should be copied to server

  5. Sites/SiteCollections would not track export/Import history

Syntax

For site collection backup

stsadm -o backup

   -url <URL name>

   -filename <file name>

   [-overwrite]

 

For catastrophic backup

stsadm -o backup

   -directory <UNC path or local drive>

   -backupmethod <full or differential>

   [-item] <created path from tree>

   [-percentage] <integer between 1 and 100>

   [-backupthreads] <integer between 1 and 10>

   [-showtree]

   [-quiet]

 

 

For site collection restore
stsadm -o restore

   -url <URL name>

   -filename <file name>

   [-hostheaderwebapplicationurl] <Web application URL>

   [-overwrite]

 

For catastrophic restore
stsadm -o restore

   -directory <UNC path>

   -restoremethod <overwrite or new>

   [-backupid] <GUID from backuphistory, see stsadm -help backuphistory>

   [-item] <created path from tree>

   [-percentage] <integer between 1 and 100>

   [-showtree]

   [-suppressprompt]

   [-username] <user name>

   [-password] <password>

   [-newdatabaseserver] <new database server name>

   [-preservechangelog]

   [-quiet]



stsadm -o export

   -url <URL name>

   -filename <export file name>

   [-overwrite]

   [-includeusersecurity]

   [-haltonwarning]

   [-haltonfatalerror]

   [-nologfile]

   [-versions] <1-4>

   [-cabsize] <integer value>

   [-nofilecompression]

   [-quiet]










stsadm -o import

   -url <URL name>

   -filename <import file name>

   [-includeusersecurity]

   [-haltonwarning]

   [-haltonfatalerror]

   [-nologfile]

   [-updateversions] <1-3>

   [-nofilecompression]

   [-quiet]


Useful Links

http://technet2.microsoft.com/Office/f/?en-us/library/16a7e571-3531-4a4e-baa7-f348a9f9d1d11033.mspx

http://blogs.msdn.com/joelo/archive/2006/10/16/what-happened-to-smigrate-exe-what-if-i-only-want-to-upgrade-one-site-what-can-i-do-now-with-stsadm-exe.aspx

http://blah.winsmarts.com/2007-10-Backup_and_Restore_Strategies_in_MOSS_2007.aspx

http://blogs.msdn.com/joelo/archive/2007/03/09/sharepoint-backup-restore-high-availability-and-disaster-recovery.aspx

Naming conventions in SharePoint vs. Windows File System

Labels:

As mentioned in my previous blog post, the naming conventions are very different

SharePoint Naming Conventions (source)

Site Names

In WSS Site Names may not contain the following characters: \ / : * ? ” < > | # { } % & ” ~ +
You cannot start a site name, subsite name, or a site group name with an underscore (_) character or with the period character
You cannot use the period character consecutively in the middle of a site name, a subsite name, or a site group name
You cannot use the period character at the end of a site name, a subsite name, or a site group name

File Names

Invalid characters: ” # % & * : < > ? \ / { | } ~ 
Cannot be longer than 128 characters
You cannot use the period character consecutively in the middle of a file name
You cannot use the period character at the end of a file name
You cannot start a file name with the period character

Folder Names

You cannot use the following characters anywhere in a folder name or a server name: ~ # % & * { } \ : < > ? / | ”
Cannot be longer than 128 characters
You cannot use the period character consecutively in the middle of a folder name
You cannot use the period character at the end of a folder name
You cannot start a folder name with the period character

Miscellaneous

The complete URL for the file or folder cannot be longer than 260 characters. Note that this includes the server, site and library name.

NTFS file system (source)

Use a period (.) to separate the base file name from the extension in a directory name or file name.
Use a backslash (\) to separate components in paths, which divides the file name from the path to it, or one directory from one another in a path. You cannot use a backslash in file or directory names. However, they can be required as part of volume names, for example, “C:\”. UNC names must have the following format:

\\<server>\<share>.

Use any character in the current code page for a name, including Unicode characters, except characters in the range of zero (0) through 31, or any character that the file system does not allow. A name can contain characters in the extended character set (128–255). However, it cannot contain the following reserved characters:
< > : ” / \ | ? *

Use a period (.) as a directory component in a path to represent the current directory.
Use two consecutive periods (..) as a directory component in a path to represent the parent of the current directory.
Do not use the following reserved device names for the name of a file: CON, PRN, AUX, NUL, COM1, COM2, COM3, COM4, COM5, COM6, COM7, COM8, COM9, LPT1, LPT2, LPT3, LPT4, LPT5, LPT6, LPT7, LPT8, and LPT9. Also avoid these names followed by an extension, for example, NUL.tx7.
Do not assume case sensitivity. Consider names such as OSCAR, Oscar, and oscar to be the same.
Do not end a file or directory name with a trailing space or a period. Although the underlying file system may support such names, the operating system does not. You can start a name with a period (.).
Maximum Path Length
In the Windows API, the maximum length for a path is MAX_PATH, which is defined as 260 characters. A path is structured in the following order: drive letter, colon, backslash, components separated by backslashes, and a null-terminating character, for example, the maximum path on the D drive is “D:\<256 chars>NUL”.

Note Functions in the Windows API convert “/” to “\” as part of converting the name to an NT style name.
The Unicode versions of several functions permit a maximum path length of approximately 32,000 characters composed of components up to 255 characters in length. To specify that kind of path, use the “\\?\” prefix.

Note The maximum path of 32,000 characters is approximate, because the “\\?\” prefix can be expanded to a longer string, and the expansion applies to the total length.

Implementing Server Hardening on SharePoint Servers

Labels:

After building our QA Server Farm Environment, we installed thrid party Server Hardening software on our web front end servers, that totally knocked out our servers, Web Aplications Created using Central Admin server were not able to Propogate to Web Front end servers, all the SharePoint solutions deployed failed. Luckily we had VMWare backups we were able to restore but there is not much documentation out there about server hardening on SharePoint farm.

Microsoft SharePoint Products and Technologies Team Blog entry has nice collection of links for different security topics on Office SharePoint Server and WSS v3, though some of the MSDN Links are broken. Below are updated links

Securing Your Web Server
Securing Your Database Server
Securing Your Network
Securing Your Application Server

MOSS Planning : Guidelines for Performance

Labels:

Recently I had an opportunity to deploy Microsoft CRM with Selentica add on to integrate with SharePoint, which created thousands of Site Collections. Initially I was little hesitant to create so many Site Collections especially after reading Microsoft Guidelines for Performance (image below).

 

 sitecollections.gif

There was really no Performance change after this deployment (We have been checking performance for a month now) may be because of my 5 Server farm, but Site Collections do give more flexibility managing content databases and security compared to sites.