<div>
If you have the database backed up, then restore it to an alternate name -dont overwrite the original!!! - then use sp2010 central admin restore to open the offline database and backup the site. Then you can restore that backup to the live site collection. 
</div>


If you have the database backed up, then restore it to an alternate name -dont overwrite the original!!! - then use sp2010 central admin restore to open the offline database and backup the site. Then you can restore that backup to the live site collection.

<div>
Does it need to be restored in the same server that hosts sharepoint's db for the central admin to be able to see it?
</div>


Does it need to be restored in the same server that hosts sharepoint's db for the central admin to be able to see it?

<div>
Nope, but the farm account will need to be dbo on that database, something that would be there if restored to the same sql server. &nbsp;
</div>


Nope, but the farm account will need to be dbo on that database, something that would be there if restored to the same sql server.  

<div>
If it is a single site that you need to reimport you will have to use export-import instead of backup-restore<br />
<a href="http://technet.microsoft.com/en-us/library/ee428301.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ee428301.aspx</a>
</div>


If it is a single site that you need to reimport you will have to use export-import instead of backup-restore
http://technet.microsoft.com/en-us/library/ee428301.aspx [http://technet.microsoft.com/en-us/library/ee428301.aspx]

<div>
Thanks very much for your responses.<br />
Fast, yours is the most complete and it covers exactly my problem.
</div>


Thanks very much for your responses.
Fast, yours is the most complete and it covers exactly my problem.

<div>
<div class="content wysiwyg-content">
A site in our intranet has been deleted by mistake.<br />
<br />
I have the whole intranet's database backed up onto tapes.<br />
<br />
Could anybody guide me as on to how to restore this particular site?<br />
<br />
The database is Ms SQL 2008, the backup software is CA Arcserve r15
</div>
</div>


A site in our intranet has been deleted by mistake.

I have the whole intranet's database backed up onto tapes.

Could anybody guide me as on to how to restore this particular site?

The database is Ms SQL 2008, the backup software is CA Arcserve r15

How to restore a single site, SharePoint 2010

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.