File: //usr/local/frontpage/currentversion/help/1033/wsgpBkup.htm
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Microsoft SharePoint Server Administration Help</title>
<SCRIPT LANGUAGE="JavaScript">
<!--
if (navigator.userAgent.indexOf("MSIE 5") != -1)
{
document.write("<LINK REL=STYLESHEET HREF=\"ows.css\" TYPE=\"text/css\">");
document.write("<STYLE>");
document.write("<<!-->");
document.write("<A:hover {color:386BCC}>");
document.write("<//-->>");
document.write("</STYLE>");
}
else
{
if (navigator.appName == "Netscape")
{
document.write("<LINK REL=STYLESHEET HREF=\"owsns.css\" TYPE=\"text/css\">");
}
else
{
document.write("<LINK REL=STYLESHEET HREF=\"owsns.css\" TYPE=\"text/css\">");
}
}
//-->
</SCRIPT>
<script LANGUAGE="JavaScript" src="ExpColla.js"></SCRIPT>
</head>
<body background="bg_help.gif" alt="Team Web Site logo" marginwidth="0" marginheight="0" rightmargin="0">
<table width="100%" cellpadding="0">
<tr>
<td><img src="desg15.gif" width="101" height="51" alt=""
border="0"></td>
<td>
<table "valign="top" width="100%"
cellpadding="1" cellspacing="0">
<tr>
<td align="right"
valign="bottom">
</td>
</tr>
<tr>
<td align="right"
valign="bottom"><a class="owsnav" href="wsgindex.htm">Index</a>
</td>
</tr>
<tr>
<td align="right"
valign="bottom"><a class="owsnav" href="wsgTOC.htm">Contents</a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" colspan="2"><a href="wsghome.htm"><img
align="right" src="home.gif"
width="12" height="11" alt="home icon" valign="top" border="0"></a><hr
NOSHADE size="1">
</td>
</tr>
<tr>
<td colspan="2" align="right"><p class="ptrail"><a
href="wsghow.htm" class="owsnav">How Do I...</a></p></td></tr>
</table>
<table class=content" width="100%" cellpadding="8">
<tr><td>
<H1 class="portal"><A name="IDX_wsgcBkup1"><!--webbot bot="PurpleText" preview = "(1)database;(2)restoring;(1)database;(2)backing up;(1)Server Administration page;(2)restoring database;(2)backing up database;(1)backups;(2)of database;(1)restoration;(2)of database;(1)maintaining the database" --></A>Back up and restore the database</H1>
<br>
<table border="0" cellpadding="0" cellspacing="0" class="exptbl">
<tr>
<td>
<LABEL for="mTools">
<IMG align="right" valign="top" border="0" width="9" height="9" src="plus.gif" class="clsImgButton" id="mToolsBtn" onClick="ToggleDisplay(mToolsBtn, mToolsItems);" alt="">
</LABEL>
</td>
<td>
<A class="clsTocHead" href="javascript:void();" id="mTools" onClick="return ToggleDisplay(mToolsBtn, mToolsItems);">
About the collaboration database
</A>
</td>
</tr>
</table>
<DIV class="clsTocItem" id="mToolsItems">
<SCRIPT>mToolsItems.style.display='none';</SCRIPT>
<DIV class="clsTocItem1">
<p>Microsoft SharePoint relies on a Microsoft SQL Server
(either <a href="wsgGloss.htm#SQLserver" class="glossterm"> SQL Server</a> 7.0 or <a href="wsgGloss.htm#MSDE" class="glossterm"> MSDE</a>)
<a href="wsgGloss.htm#database" class="glossterm"> database</a> to store
information such as:</p>
<UL>
<LI><b>List data </b> Information about <a href="wsgGloss.htm#Eventslist" class="glossterm">Events</a>,
<a href="wsgGloss.htm#Announcementslist" class="glossterm">Announcements</a>,
<a href="wsgGloss.htm#Taskslist" class="glossterm">Tasks</a>,
<a href="wsgGloss.htm#Contactslist" class="glossterm">Contacts</a>, and
other lists in a Microsoft SharePoint-based team Web site</LI>
<LI><b>Document library information </b> <a href="wsgGloss.htm#properties" class="glossterm">Properties</a>, such as document title, date, and size</LI>
<LI><b>Discussion and subscription data</b> <a href="wsgGloss.htm#subscription" class="glossterm">Subscription</a>
information and the actual threaded <a href="wsgGloss.htm#discussioncomment" class="glossterm"> comments</a> from
<a href="wsgGloss.htm#discussion" class="glossterm">discussions</a></LI>
<LI><b>Security data</b></LI>
</UL>
<p>Each <a href="wsgGloss.htm#virtualserver" class="glossterm">virtual server</a>
has its own database. The Webs and <a href="wsgGloss.htm#subweb" class="glossterm">
subwebs</a> on that virtual server share the database, although their information is
stored in separate tables within the database.</p>
<p>As a server <a href="wsgGloss.htm#Administratorrole" class="glossterm">administrator</a>, you can specify database settings. For example,
you can schedule automatic back-up
processes or specify the default database to
use for all Webs on a virtual server.</p>
<p>Administrators with <a href="wsgGloss.htm#rights" class="glossterm"> rights</a> to the virtual server can back up or restore the
database for the entire virtual server.</p>
</DIV>
</DIV>
<table border="0" cellpadding="0" cellspacing="0" class="exptbl">
<tr>
<td>
<LABEL for="mNap">
<IMG align="right" valign="top" border="0" width="9" height="9" src="plus.gif" class="clsImgButton" id="mNapBtn" onClick="ToggleDisplay(mNapBtn, mNapItems);" alt="">
</LABEL>
</td>
<td>
<A class="clsTocHead" href="javascript:void();" id="mNap" onClick="return ToggleDisplay(mNapBtn, mNapItems);">
To back up the database
</A>
</td>
</tr>
</table>
<DIV class="clsTocItem" id="mNapItems">
<SCRIPT>mNapItems.style.display='none';</SCRIPT>
<DIV class="clsTocItem1">
<OL>
<LI>On the <b>Server Administration</b> page, under
<b>Virtual Servers</b>, click the <b>Administration</b>link
next to the <a href="wsgGloss.htm#virtualserver" class="glossterm"> virtual server</a> you want to backup.</LI>
<LI>Under
<b>Administration</b>, click <b>Backup</b> <b>and</b> <b>restore database</b>.</LI>
<LI>In the <b>Database Backup</b> area, type the path and filename to use for the backup file.
<p>The backup process creates a backup file with the filename and path you specify. Be sure that the path you type is a valid path on your server
computer.</LI>
<LI>Click <b>Backup</b>.</LI>
</OL>
</DIV>
</DIV>
<table border="0" cellpadding="0" cellspacing="0" class="exptbl">
<tr>
<td>
<LABEL for="mNac">
<IMG align="right" valign="top" border="0" width="9" height="9" src="plus.gif" class="clsImgButton" id="mNacBtn" onClick="ToggleDisplay(mNacBtn, mNacItems);" alt="">
</LABEL>
</td>
<td>
<A class="clsTocHead" href="javascript:void();" id="mNac" onClick="return ToggleDisplay(mNacBtn, mNacItems);">
To restore the database
</A>
</td>
</tr>
</table>
<DIV class="clsTocItem" id="mNacItems">
<SCRIPT>mNacItems.style.display='none';</SCRIPT>
<DIV class="clsTocItem1">
<OL>
<LI>On the <b>Server Administration</b> page, under
<b>Virtual Servers</b>, click the <b>Administration</b>link
next to the <a href="wsgGloss.htm#virtualserver" class="glossterm"> virtual server</a> you want to backup.
</LI>
<LI>Under
<b>Administration</b>, click <b>Backup</b> <b>and</b> <b>restore database</b>.</LI>
<LI>In
the <b>Database Restore</b> area, type the path and filename of the backup
file you want to restore.</LI>
<LI>Click <b>Restore</b>.</LI>
</OL>
</DIV>
</DIV>
</td></tr></table>
<table class="footer" align="center">
<tr>
<td><img src="1p.gif" height="10px" width="10px"></td>
</tr>
<tr>
<td>
<p><a class="owsnav" href="wsghome.htm">Home</a> | <a class="owsnav" href="wsgindex.htm">Index</a> | <a class="owsnav" href="wsgTOC.htm">Contents</a></p>
</td>
</tr>
<tr>
<td>©2001 Microsoft Corporation
<br>
All rights reserved. <a href="wscopyrt.htm">Terms of use.</a></p>
</td>
</tr>
</table>
</body>
</html>