Restoring Single Site in Sharepoint

Taking Backup & Restore of Sharepoint with stsadm mode : (Command line Mode )

There are some advantages of command line backup and restore they are:
It is a fast and "full-fidelity" procedure; that is, it will exactly restore the sites you backed up, including security settings and personal site views. This tool has some limitations and behaviors you must be aware of, such as:
1> It can back up and restore a complete farm, a single site collection, or a single site.
2> The result will be stored as a file. STSADM cannot write to other backup media.
3> It must be executed on the SharePoint server.
4> You must be a SharePoint server administrator to run STSADM.
5> This is a command-line tool. There is no graphical user interface included for this tool.

Taking a stsadm -o backup :

Open the folder C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN in command prompt
Type command stsadm –o backup –url -filename
After the process is complete you will see backup.bak file located in c:\

Taking a stsadm -o export :

Open the folder C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN in command prompt

Type command stsadm –o export –url -filename

After the process is complete you will see backup.cmp file located in c:\

Features :
It can back up and restore single sites.

It can back up any site including its sub sites.

It does not have to be the top-level site in the site collection.

It can restore the site permissions The result will be stored as a file.

It must be executed on a SharePoint server with a Central Administration tool installed.

You must be the site administrator to run this command.

This is a command line tool. You can schedule it using Windows Tasks.

===============================================================

The main diffrence between Export and Backup is that export can be used to take a backup of single site collection

The backup taken via command line commpresses dats so if you compare the file size from SQL this will always be reduced

You can perform operations like taking a backup of a subsite from one web application and restoring it to top level sitye collection on another web application with his mode of backup

Restore Commands :

Open the folder C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN in command prompt

Type command stsadm –o restore –url -filename

for export type of backup use restore command as

stsadm -o import -url -filename